SQL Server Performance Forum – Threads Archive

SQL Profiler shows 0 for Reads

When I run SQL Profiler on one of my SQL Servers (version 2000 SP3a), it always shows 0 in the Reads data column, no matter what query I was running. I’ve tried running a long query involving scan of a large table, it still showed Reads = 0 Anybody has any idea about this? The Reads data column should show the logical disk reads. When I run the same Profiler and the same query on another server, it shows a huge number for Reads. The other server has exactly the same Windows version and SQL server version and the same service pack. sp_configure on both servers showed the same configuration values, including the advanced options. Thanks in advance Rupeng

Your server has problem with counters.
Check any related message in Event Viewer.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Also check:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6506 Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks Luis for the advice. That was exactly the problem addreesed by the hotfix
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k It saved my day. Thanks again.
Rupeng Rupeng

]]>