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.

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.