Continuous alerts for SQL

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

    • Troubleshooting tips for log collection errors

      The following is a list of possible log collection errors and the solutions to fix them: Error message Reason Solution Upload Limit Reached You might have reached the maximum upload limit configured for this log type in the current billing cycle. ...
    • 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 in case of performance counter test failure or value mismatch

      From the Site24x7 web client, go to Network > Network Device . Click on the desired device name and go to the Performance Counters tab. Click Test on the desired performance counter.  Copy the Device Identifier/OID from the Test Performance Counter ...
    • Troubleshooting steps for On-Premise Poller

      Prerequisites and basic details: Prerequisites for installing On-Premise Poller Necessary ports to allow access to the installed On-Premise Poller How secure is On-Premise Poller Amount of bandwidth consumed by the On-Premise Poller software Adding ...
    • How to map the severity of alerts from Site24x7 in Moogsoft ?

      By default, these are the corresponding severities in Moogsoft for alerts raised from Site24x7.                  Site24x7 Alert Status                   Corresponding Moogsoft Severity                               Up                                 ...