You administer a Microsoft SQL Server 2012 failover cluster.
You need to ensure that a failover occurs when the server diagnostics returns
query_processing error.
Which server configuration property should you set?
A.
SqlOumperDumpFlags
B.
FailureConditionLevel
C.
HealthCheckTimeout
D.
SqlDumperDumpPath
.. correct answer : C
@see https://msdn.microsoft.com/en-us/library/ff878664.aspx
I don’t think, for me C is correct, FailureConditionLevel (set at 5)
Sorry B is correct
https://msdn.microsoft.com/en-us/library/gg471591(v=sql.110).aspx
Before I wanted to write B, that right?
Correct answer is B. FailureCconditionlevel 5.
See https://msdn.microsoft.com/en-us/library/ff878664.aspx
Only Level 5 corresponds with query_processing errors
Extremely individual friendly site. Astounding information readily available on few gos to.|
csgo skins addon http://blogs.psychologies.com/madden-15-coins/skins-studying-fundamentals-252503.html
Finally found the solution. Check it out yourSelf.
https://blogs.msdn.microsoft.com/alwaysonpro/2014/11/26/diagnose-unexpected-failover-or-availability-group-in-resolving-state/