Return
-
Title
What rule can be used to monitor SQL Server database log files? -
Description
What rule can be used to monitor SQL Server database log files?
-
Resolution
The "DBSS - Log File Utilization rule" alarm invokes an alarm when a database log files is reaching its full capacity. This alarm is raised to prevent a situation where a log file that fills its current capacity cannot grow enough to resolve this issue, thereby causing the database to hang.
Users can also create a custom a rule to use the metrics in the Database Information collection of the SQL Server agent or engage Professional Services for assistance with customizations.