|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Reads in Profiler
Why am I showing Reads = 0 for all the select, insert, update, etc.
statements that are shown executed in SQL Profiler? Are you looking at the *Starting or *Completed event?
-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "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 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? Robert R via SQLMonster.com wrote:
> I am looking at SQL:BatchCompleted and RPC:Completed. Please post the exact version of SQL Server (SELECT @@VERSION) and the > > 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? 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. |
|||||||||||||||||||||||