Hitachi

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


1.3 Example of performance monitoring using PFM - RM for Microsoft SQL Server

Performance monitoring is critical for the setup and management of Microsoft SQL Server environments. The following explains the purpose of performance monitoring using PFM - RM for Microsoft SQL Server, and provides an example of performance monitoring.

Performance monitoring using PFM - RM for Microsoft SQL Server can be used to perform the following:

During Microsoft SQL Server operation, specific causes can negatively impact overall Microsoft SQL Server performance. These causes can include the following:

It is very important to make sure that the Microsoft SQL Server is running properly. In addition to performance standpoints, monitoring such as the following can be used to check whether a Microsoft SQL Server is running properly.

Performance monitoring using PFM - RM for Microsoft SQL Server can be performed to achieve stable operation for Microsoft SQL Server servers.

Note that the performance monitoring method thresholds are for reference only. The actual thresholds need to be determined through baseline measurement.

The actual items set need to be determined based on the type of operation for the Microsoft SQL Server.

Organization of this section