Profiler Issue

Last Post 03 Sep 2004 06:42 AM by satya. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Corwin
New Member
New Member

--
10 Aug 2004 10:03 AM
Has anybody ran across the problem that when using the default template in profiler it does not gather the Reads in the trace. Am I doing something wrong?
satya
New Member
New Member

--
03 Sep 2004 06:42 AM
CHeck what events were selected.
Corwin
New Member
New Member

--
03 Sep 2004 06:51 AM
These are the events that we are traceing:

-- Event 12 = 'Batch completed'
EXEC master..sp_trace_setevent @TraceID, 12, 27, @On-- Event Class
EXEC master..sp_trace_setevent @TraceID, 12, 1, @On -- Text Data
EXEC master..sp_trace_setevent @TraceID, 12, 3, @On -- DatabaseID
EXEC master..sp_trace_setevent @TraceID, 12, 6, @On -- NTUserName
EXEC master..sp_trace_setevent @TraceID, 12, 11, @On -- SQLSecurityLoginName
EXEC master..sp_trace_setevent @TraceID, 12, 8, @On -- ClientHostName
EXEC master..sp_trace_setevent @TraceID, 12, 10, @On -- ApplicationName
EXEC master..sp_trace_setevent @TraceID, 12, 13, @On -- Duration
EXEC master..sp_trace_setevent @TraceID, 12, 14, @On -- StartTime
EXEC master..sp_trace_setevent @TraceID, 12, 15, @On -- EndTime
EXEC master..sp_trace_setevent @TraceID, 12, 16, @On -- Reads
EXEC master..sp_trace_setevent @TraceID, 12, 17, @On -- Writes
EXEC master..sp_trace_setevent @TraceID, 12, 18, @On -- CPU
pyale
New Member
New Member

--
12 Sep 2004 02:38 AM
When you say it does not gather the reads, do you mean that the column is permanently blank, or that the column simply isn't there? We've had instances where the READS figures stop recording (as do WRITES), and the only solution has been to stop/start the SQLServer service. Not too pretty in a production environment, but it did the trick.

Interestingly, it seems to be a bounce of the server that causes the counters to go AWOL in the first place. This has happened to us more than once, and we now include a Profiler counter check after any stop/start of our dataservers.
You are not authorized to post a reply.

Acceptable Use Policy