Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, September 19, 2013 11:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912
Leo.Miller (1/13/2011)
ramadesai108 (1/13/2011)
Hello,
When I see high numbers in READS and WRITES columns in Profiler, what does that mean? How can I improve that?

Thanks.


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.

Leo


As per profiler definition:

Writes:

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