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.