| title | sys.dm_os_server_diagnostics_log_configurations | ||||
|---|---|---|---|---|---|
| description | sys.dm_os_server_diagnostics_log_configurations | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-fabricsqldb]
Returns one row with the current configuration for the [!INCLUDEssNoVersion] 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.
| 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 [!INCLUDEssNoVersion] failover cluster instance. |
Requires VIEW SERVER STATE permissions on the SQL Server failover cluster instance.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
The following example uses sys.dm_os_server_diagnostics_log_configurations to return the property settings for the [!INCLUDEssNoVersion] failover diagnostic logs.
SELECT <list of columns>
FROM sys.dm_os_server_diagnostics_log_configurations;
[!INCLUDEssResult]
| IS_ENABLED | PATH | MAX_SIZE | MAX_FILES |
|---|---|---|---|
| 1 | <C:\Program Files\Microsoft SQL Server\MSSQL13\MSSQL\Log> | 10 | 10 |