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 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                                 ...
    • 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 ...
    • Security for SQL Server Monitoring

      Do I have to provide my SQL Server credentials for Site24x7 to monitor them? No, Site24x7 does not ask for your SQL Server credentials for monitoring. Does Site24x7 connect to the SQL Servers directly? No, Site24x7 does not connect to the SQL ...
    • DNSSEC validation results and troubleshooting tips

      After adding a DNS server monitor, you can validate your DNS responses by enabling Domain Name System Security Extensions (DNSSEC). DNSSEC is a set of protocols that add an extra layer of security to the DNS lookup and exchange processes by digitally ...