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

Performance monitoring is critical for the setup and management of Microsoft SQL Server environments.

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

• Analysis of performance data to discover causes of bottlenecks

• Monitoring to check whether the Microsoft SQL Server is running properly

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

• Insufficient data cache

• CPU usage ratio per session

• Insufficient log space

• Insufficient database space

• Increase in the number of locks

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.

• Network load monitoring

• Instance validity

Performance monitoring using PFM - Agent 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

• 1.3.1 Determining a baseline

• 1.3.2 Insufficient data cache

• 1.3.3 CPU usage ratio per session

• 1.3.4 Insufficient log space

• 1.3.5 Insufficient database space

• 1.3.6 Increase in the number of locks

• 1.3.7 Network load

• 1.3.8 Instance validity

To Page Top