PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server 2016 failover cluster.

You administer a Microsoft SQL Server 2016 failover cluster.

You need to ensure that a failover occurs when the server diagnostics return

s query_processing error.

Which server configuration property should you set?

A. SqlOumperDumpFlags

B. FailureConditionLevel

C. HealthCheckTimeout

D. SqlDumperDumpPath

The SQL Server Database Engine resource DLL determines whether the detected

health status is a condition for failure using the FailureConditionLevel property. The FailureConditionLevel property defines which detected health statuses cause restarts or failovers. Multiple levels of options are available, ranging from no automatic r

estart or failover to all possible failure conditions resulting in an automatic restart or failover.

References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/failover-policy-for-failover-cluster-instances


Leave a Reply