Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

High READS and WRITES number in profiler Expand / Collapse
Posted Thursday, September 19, 2013 11:16 AM


Group: General Forum Members
Last Login: Friday, November 18, 2016 9:50 AM
Points: 1,525, Visits: 3,573
Leo.Miller (1/13/2011)
ramadesai108 (1/13/2011)
When I see high numbers in READS and WRITES columns in Profiler, what does that mean? How can I improve that?


Reducing READS tends to be simpler as improved indexing may reduce this. You need to be aware that the READS and WRITES you see in profiler are not only to disk, but include cache reads and writes, so they may be a bit misleading.


As per profiler definition:


Number of physical disk writes performed by the server on behalf of the event.

So they are physical writes.
Post #1496503
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse