Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-14 : 07:21:16
|
| Paul writes "Hi,I am trying to analyse a trace taken by SQL Profiler on behalf of a client with a busy server. I am using a standard trace template with the database name and id columns added. Once I have the trace into a table I drop some columns and end with the following columns (plus an example on an entry) RowNumber TextData DatabaseID LoginName SPID Duration StartTime Reads Writes CPU DatabaseName 103853 NULL 5 sa 286 25241016 2004-06-10 08:28:57.060 130349 0 5030 NULLMy question is this, I have some 1600 or so queries (from a trace of over 200,000 rows) where the duration is long, the starttime is many hours prior to the start of my trace and where the textdata is NULL. Can anyone shed some light on what this sort of entry is about or point me in the direction to figure this out for myself please? Thanks in advance and regards from Paul Reynolds." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-06-14 : 07:21:17
|
| What is the Event Class of the row in question? My guess is that it's a logout event. |
 |
|
|
|
|
|
null textdata column in sql profiler long running queries