Home All Groups Group Topic Archive Search About


Author
23 Jan 2006 9:24 PM
Robert R via SQLMonster.com
Why am I showing Reads = 0 for all the select, insert, update, etc.
statements that are shown executed in SQL Profiler?


Author
23 Jan 2006 9:42 PM
Tibor Karaszi
Are you looking at the *Starting or *Completed event?

Show quoteHide quote
"Robert R via SQLMonster.com" <u3288@uwe> wrote in message news:5acdda181290e@uwe...
> Why am I showing Reads = 0 for all the select, insert, update, etc.
> statements that are shown executed in SQL Profiler?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
Are all your drivers up to date? click for free checkup

Author
23 Jan 2006 10:21 PM
Robert R via SQLMonster.com
I am looking at SQL:BatchCompleted and RPC:Completed.

When I pull the query statement from Profiler, and execute in query analyzer
with "SET STATISTICS IO ON", I receive hords or logical reads, yet no reads
appear in Profiler.

Tibor Karaszi wrote:
>Are you looking at the *Starting or *Completed event?
>
>> Why am I showing Reads = 0 for all the select, insert, update, etc.
>> statements that are shown executed in SQL Profiler?

Author
23 Jan 2006 11:51 PM
David Gugick
Robert R via SQLMonster.com wrote:
> I am looking at SQL:BatchCompleted and RPC:Completed.
>
> When I pull the query statement from Profiler, and execute in query
> analyzer with "SET STATISTICS IO ON", I receive hords or logical
> reads, yet no reads appear in Profiler.
>
> Tibor Karaszi wrote:
>> Are you looking at the *Starting or *Completed event?
>>
>>> Why am I showing Reads = 0 for all the select, insert, update, etc.
>>> statements that are shown executed in SQL Profiler?

Please post the exact version of SQL Server (SELECT @@VERSION) and the
Profiler client (Help | About). I've seen the problem reported in the
past with CPU (addressed with SP4 and prior with a Hotfix) and I think
I've seen it posted a few time regard Duration. You may want to Google
it to see if it turns up anything.

--
David Gugick
Quest Software
www.quest.com

Bookmark and Share