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:Writes:
Number of physical disk writes performed by the server on behalf of the event.
So they are physical writes.