Page History
...
Metric | Why it is important |
|---|---|
Disk reads/sec | A high number of disk reads may indicate that the SQL Server is executing poorly-performing queries. |
Disk writes/sec | A high number of disk writes may indicate that the SQL Server is running low on allocated memory . |
| Anchor | ||||
|---|---|---|---|---|
|
...
Metric | Why it is important |
|---|---|
Checkpoint writes | A high number of checkpoint writes may indicate that pages are not written to disk quickly enough for optimal performance. |
Lazy writer writes | A high number of lazy writer writes may indicate that the SQL Server is running low on allocated memory. . |
A high number of page reads may indicate that the SQL Server is executing inefficient queries or that you should optimize the database indexes. | |
A high number of page writes may indicate that the SQL Server is executing inefficient queries or that you should optimize the database indexes. | |
Read ahead reads | A high number of read ahead reads may indicate that you should tune your query execution plan or that you should defragment the disk. |
...