Skip to content

sys-dm-os-cluster-properties-transact-sql.md

Latest commit

 

History

History
62 lines (51 loc) · 4.18 KB

sys-dm-os-cluster-properties-transact-sql.md

File metadata and controls

62 lines (51 loc) · 4.18 KB
title sys.dm_os_cluster_properties (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 08/09/2016
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
sys.dm_os_cluster_properties_TSQL
sys.dm_os_cluster_properties
dm_os_cluster_properties_TSQL
dm_os_cluster_properties
dev_langs
TSQL
helpviewer_keywords
dm_os_cluster_properties
sys.dm_os_cluster_properties
ms.assetid 6d82e770-fba7-49e0-9a0c-3b34b393e4a7
caps.latest.revision 17
author JennieHubbard
ms.author jhubbard
manager jhubbard

sys.dm_os_cluster_properties (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

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

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 [!INCLUDEssNoVersion] failover cluster instance.

Column Name Property Description
VerboseLogging bigint The 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).
SqlDumperDumpFlags bigint SQLDumper dump flags determine the type of dump files generated by [!INCLUDEssNoVersion]. The default setting is 0.
SqlDumperDumpPath nvarchar(260) The location where the SQLDumper utility generates the dump files.
SqlDumperDumpTimeOut bigint The time-out value in milliseconds for the SQLDumper utility to generate a dump in case of a [!INCLUDEssNoVersion] failure. The default value is 0.
FailureConditionLevel bigint Sets the conditions under which the [!INCLUDEssNoVersion] 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.
HealthCheckTimeout bigint The 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.

Permissions

Requires VIEW SERVER STATE permissions on the [!INCLUDEssNoVersion] failover cluster instance.

Examples

The following example uses sys.dm_os_cluster_properties to return the property settings for the [!INCLUDEssNoVersion] failover cluster resource.

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

Here is a sample result set.

VerboseLogging SqlDumperDumpFlags SqlDumperDumpPath SqlDumperDumpTimeOut FailureConditionLevel HealthCheckTimeout
0 0 NULL 0 3 60000