November 22, 2004 at 5:38 pm
Out of 25 production SQL Servers, one server has the column Reads show as 0 for all events that are profiled. I typically run profiler for a few minutes at a time when I want to investigate a real time performance hit.
I have a template that filters for specific the events. I run profiler from a non production box and authenticate to the production server I want to profile. I use the same template each time I run profiler, and all other boxes show a non 0 value for the Read column.
On the box that shows 0 for Reads in profiler, I ran one sproc in QA with I/O Statistics on and got 1000 + logical reads which is what the profiler column is supposed to count. This same sproc still showed 0 reads in profiler.
I am thinking there is a setting somewhere that I am not familiar with, but can't seem to find any information for it. Has this happened to anyone else, and if so how did you fix it?
Thanks for any input.
November 25, 2004 at 8:00 am
This was removed by the editor as SPAM
June 30, 2005 at 3:14 am
Grasshopper,
Did you ever discover what was causing the problem?
I've just noticed the same problem on one of my servers and would like to know what causes it.
I'm running SQL 2000 Enterprise Edition sp3 on a Win 2000 sp4 box.
Thanks in advance
July 5, 2005 at 2:13 pm
No I never did find the exact problem that caused this. Since it was not mission critical and that server was retired for end of life, I decided to just let the sleeping dog lie. If you do ever come across the resolution, I would be interested in knowing. Good luck to you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply