Here are some important perfomon counters that can be captured to track the performance of SQL Server.
Average Disk sec/read – measures how much time it takes to for an IO request to be sent from the application to the storage system
Average Disk sec/read – measures how much time it takes to for an IO request to be sent from the storage system to the application
Disk read/sec and disk write/sec – track the physical data being transferred
Disk Queue length let’s us know how busy the system
% Processor time – shows the processor load on the server.
System: Processor Queue Length – determines how many tasks are waiting on the CPU.
Memory : Available Mbytes – tells the memory currently in use
How does SQL Server read and write ?
- normally Reads in 64K data extents
- normally Writes in 8K data pages
0 Comments.