Skip to content

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

Latest commit

 

History

History
70 lines (55 loc) · 4.75 KB

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

File metadata and controls

70 lines (55 loc) · 4.75 KB
Raw
title sys.dm_os_cluster_properties (Transact-SQL)
description sys.dm_os_cluster_properties returns one row with the current settings for the SQL Server cluster resource properties.
author rwestMSFT
ms.author randolphwest
ms.date 04/22/2026
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sys.dm_os_cluster_properties_TSQL
sys.dm_os_cluster_properties
dm_os_cluster_properties_TSQL
dm_os_cluster_properties
helpviewer_keywords
sys.dm_os_cluster_properties dynamic management view
dm_os_cluster_properties
sys.dm_os_cluster_properties
dev_langs
TSQL

sys.dm_os_cluster_properties (Transact-SQL)

[!INCLUDE SQL Server]

Returns one row with the current settings for the [!INCLUDE ssNoVersion] cluster resource properties identified in this article. If you run this view on a stand-alone instance of [!INCLUDE ssNoVersion], it returns no data.

You can use these properties to set values that affect failure detection, failure response time, and the logging for monitoring the health status of the [!INCLUDE ssNoVersion] failover cluster instance.

Column name Data type Nullable Description
VerboseLogging bigint Yes The logging level for the SQL Server failover cluster. Turn on verbose logging to provide extra 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.
SqlDumperDumpFlags bigint Yes SQLDumper dump flags determine the type of dump files generated by [!INCLUDE ssNoVersion]. The default setting is 0.
SqlDumperDumpPath nvarchar(260) No The location where the SQLDumper utility generates the dump files.
SqlDumperDumpTimeOut bigint Yes The timeout value in milliseconds for the SQLDumper utility to generate a dump if [!INCLUDE ssNoVersion] fails. The default value is 0.
FailureConditionLevel bigint Yes Sets the conditions under which the [!INCLUDE ssNoVersion] 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 Yes The timeout 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 timeout value is expressed in milliseconds. Default is 60000 (60,000).

For more information or to change this property setting, see Configure HealthCheckTimeout Property Settings.
ClusterConnectionOptions nvarchar(4000) Yes For more information about these options, see the Cluster connection options section.

Cluster connection options

[!INCLUDE cluster-connection-options]

For more information, see CREATE AVAILABILITY GROUP and ALTER AVAILABILITY GROUP.

Permissions

[!INCLUDE sssql19-md] and earlier versions require VIEW SERVER STATE permissions on the [!INCLUDE ssNoVersion] failover cluster instance.

[!INCLUDE sssql22-md] and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.

Examples

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

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

[!INCLUDE ssresult-md]

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