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 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.