Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


1.3.5 Insufficient database space

The insufficient database space affects the performance of the Microsoft SQL Server. To monitor the insufficient database space, use the Database Space alarm which PFM - RM for Microsoft SQL Server provides. The Database Space alarm enables you to monitor the available space for each database.

The following table explains the Database Space alarm in the monitoring template:

Alarm name

Record used

Field used

Abnormal condition

Warning condition

Values measured

Database Space

PD_DS

Free %

Free % < 10

Free % < 20

Available space for database can be insufficient.

Diagnosis:

If the value of Database Space is less than 10 %, the available space for databases can be insufficient.

Prescription:

Reconsider how to access the Microsoft SQL Server database

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