Reads in Trace Profiler

Last Post 27 May 2008 05:59 PM by SQLUSA. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
chokachi
New Member
New Member

--
27 May 2008 08:45 AM

why i get always "0" in column "Reads" when i run a SQL Server 2000 trace ?

To Stored Procedures RPC:Completed and TSQL Batch:BatchCompleted.

In SQL Server Production with 2 000 000 execution Business Hours...
SQLUSA
New Member
New Member

--
27 May 2008 05:59 PM
quote:

Originally posted by: chokachi

why i get always "0" in column "Reads" when i run a SQL Server 2000 trace ?

.


Do you get "writes", "cpu", duration?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
chokachi
New Member
New Member

--
28 May 2008 12:32 AM
I have some executions with writes and cpu

this is happening for 2 weeks until now...
SQLUSA
New Member
New Member

--
28 May 2008 12:43 AM
What SP are you on?

What happened 2 weeks ago?

How are you saving the trace? File? Table?

Are you running the GUI trace?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy