Troubleshooting tips when there are continuous alerts for SQL performance metrics including page reads/sec, page writes/sec, page life expectancy
Page reads and writes per second denote the number of physical database page reads and writes issued respectively.
Page life expectancy is the number of seconds a page will stay in the buffer pool without references. These are critical performance metrics to gain deep understanding of various memory and buffer manager details for optimal capacity planning.
In case you receive continuous alerts for reaching high values for these metrics, contact your SQL DB Admin and analyze if there are inefficient queries, insufficient memory or cache, and review the table schema.
Tip: If you do not prefer to be alerted continuously for these metrics, change your preferences in the SQL threshold profile. Log in to Site24x7 and go to Server > Microsoft SQL Server > click on the monitor > hover on the hamburger icon beside the display name > Edit > click on the pencil icon beside Threshold and Availability > edit the threshold values and Save the changes.
Related Articles
How to configure the NGINX status page for monitoring NGINX performance
The NGINX plugin uses the NGINX status page to pull the performance metrics of the NGINX server. You may encounter the following errors while installing the NGINX plugin integration: Error_code : HTTP Error 404: This error usually indicates that the ...
Troubleshooting steps when no data is received from the SQL server
As we use "Perfmon" to fetch data for Microsoft SQL monitoring, please check if the counters related to SQL are present in the user's perfmon. Please follow the steps below: Open the server machine in which the issue is occurring. Start -> Run and ...
Troubleshooting false positive alerts in monitoring
Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...
Site24x7 Real User Monitoring (RUM) - Data Collection
When you include Site24x7 RUM beacon script in your web pages, the following data is collected. All data that's being collected is in accordance with GDPR compliance. Performance details of web page load time - Metrics like response time of web page ...
Compare our various methodologies for Website Monitoring
Get to know Site24x7 monitors better and choose the one that best fits your monitoring needs. Compare the functionality of the following monitors: Website Monitoring Webpage Speed (Browser) Web Transaction Monitoring Web Transaction (Browser) SSL/TLS ...