sys.dm_os_server_diagnostics_log_configurations

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2012)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns one row with the current configuration for the SQL Server failover cluster diagnostic log. These property settings determine whether the diagnostic logging is on or off, and the location, number, and size of the log files.

||
|-|
|Applies to: SQL Server ( SQL Server 2012 through current version).|

Column Name Data Type Description
is_enabled bit Indicates if the logging is turned on or off.

1 = Diagnostics logging is turned on

0 = Diagnostics logging is turned off
max_size int Maximum size in megabytes to which each of the diagnostic logs can grow. The default is 100 MB.
max_files int Maximum number of diagnostic log files that can be stored on the computer before they are recycled for new diagnostic logs.
path nvarchar(260) Path indicating the location of the diagnostic logs. The default location is <\MSSQL\Log> within the installation folder of the SQL Server failover cluster instance.

Permissions

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

Examples

The following example uses sys.dm_os_server_diagnostics_log_configurations to return the property settings for the SQL Server failover diagnostic logs.

SELECT <list of columns>  
FROM sys.dm_os_server_diagnostics_log_configurations;  

Here is the result set.

IS_ENABLED PATH MAX_SIZE MAX_FILES
1 <C:\Program Files\Microsoft SQL Server\MSSQL13\MSSQL\Log> 10 10

See Also

View and Read Failover Cluster Instance Diagnostics Log