Home Forums SQL Server 2005 Administering High READS and WRITES number in profiler RE: High READS and WRITES number in profiler

  • September 19, 2013 at 11:16 am

    #1651600

    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.