TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sys.dm_os_cluster_properties (Transact-SQL)

 

Updated: August 9, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns one row with the current settings for the SQL Server cluster resource properties identified in this topic. No data is returned if this view is run on a stand-alone instance of SQL Server.

These properties are used to set the values that affect failure detection, failure response time, and the logging for monitoring the health status of the SQL Server failover cluster instance.

Column NamePropertyDescription
VerboseLoggingbigintThe logging level for the SQL Server failover cluster. Verbose logging can be turned on to provide additional details in the error logs for troubleshooting. One of the following values:

0 – Logging is turned off (default)

1 - Errors only

2 – Errors and warnings

For more information, see ALTER SERVER CONFIGURATION (Transact-SQL).
SqlDumperDumpFlagsbigintSQLDumper dump flags determine the type of dump files generated by SQL Server. The default setting is 0.
SqlDumperDumpPathnvarchar(260)The location where the SQLDumper utility generates the dump files.
SqlDumperDumpTimeOutbigintThe time-out value in milliseconds for the SQLDumper utility to generate a dump in case of a SQL Server failure. The default value is 0.
FailureConditionLevelbigintSets the conditions under which the SQL Server failover cluster should fail or restart. The default value is 3. For a detailed explanation or to change the property settings, see Configure FailureConditionLevel Property Settings.
HealthCheckTimeoutbigintThe time-out value for how long the SQL Server Database Engine resource DLL should wait for the server health information before it considers the instance of SQL Server as unresponsive. The time-out value is expressed in milliseconds. Default is 60000. For more information or to change this property setting, see Configure HealthCheckTimeout Property Settings.

Requires VIEW SERVER STATE permissions on the SQL Server failover cluster instance.

The following example uses sys.dm_os_cluster_properties to return the property settings for the SQL Server failover cluster resource.

SELECT VerboseLogging, SqlDumperDumpFlags, SqlDumperDumpPath, SqlDumperDumpTimeOut, FailureConditionLevel, HealthCheckTimeout  
FROM sys.dm_os_cluster_properties;  

Here is a sample result set.

VerboseLoggingSqlDumperDumpFlagsSqlDumperDumpPathSqlDumperDumpTimeOutFailureConditionLevelHealthCheckTimeout
00NULL0360000

Community Additions

ADD
Show:
© 2016 Microsoft