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

  • January 13, 2011 at 12:50 pm

    #1273249

    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

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.