The SQL Server Log Used (Percent) alert provides the percentage of allocated disk space used by logs on the SQL Server instance reached an alert threshold. Once the log space is completely filled, all updates to the event log fail.
This alert is raised based on the database metrics collection interval specified in Server Properties. For more information, see Set general server options.
Reduce your SQL Server log space used
- You can allocate more disk space to the event log, turn on the auto-growth feature for your SQL Server log, or add additional disk space to the computer hosting your SQL Server instance.
- If autogrowth is turned off for your logs, this alert may indicate the need to either increase the allocated space for logs and/or add disk space to your SQL Server environment.
- If autogrowth is turned on and you are seeing this alert often, you may need to adjust your autogrowth settings to a higher percentage to improve degraded performance resulting from constant growth adjustments.
- In certain cases, SQL Diagnostic Manager may incorrectly report the file size. This issue occurs when certain columns in the 'sysindexes' table in SQL Server 2000 become inaccurate and provide SQL Diagnostic Manager with incorrect information regarding the number of rows and table size.
- Use the following T-SQL syntax to correct this issue:
DBCC UPDATEUSAGE ('database_name' ) GO
We recommend that you execute this command during non-peak hours as it is server intensive.
To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window.