The insufficient log space affects the performance of the Microsoft SQL Server. To monitor the insufficient log space, use the Log Space Usage alarm which PFM - RM for Microsoft SQL Server provides. The Log Space Usage alarm enables you to monitor the top 10 most log-space used database.
The following table explains the Log Space Usage alarm in the monitoring template:
Alarm name | Records used | Field used | Abnormal condition | Warning condition | Values measured |
---|---|---|---|---|---|
Log Space Usage | PI_TLOG | Log Space Used % | Log Space Used % > 90 | Log Space Used % > 80 | Log space can be insufficient. |
For details about the Log Space Usage alarm, see Log Space Usage in 4. Monitoring Template.