1.3.4 Insufficient log space

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 nameRecords usedField usedAbnormal conditionWarning conditionValues measured
Log Space UsagePI_TLOGLog Space Used %Log Space Used % > 90Log Space Used % > 80Log space can be insufficient.
Diagnosis:
If the value of Log Space Used % exceeds 90 %, the log space can be insufficient.
Prescription:
Add a transaction log file or enlarge the size of the transaction log file.

For details about the Log Space Usage alarm, see Log Space Usage in 4. Monitoring Template.