July 6, 2010 at 3:12 am
In SQL 2005 Standard Trace Template, are there any documentation explanining each fields ( for ex: clientprocessid )
July 6, 2010 at 3:47 am
Books Online?
http://msdn.microsoft.com/en-us/library/ms175481%28SQL.90%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2010 at 4:20 am
In Profiler, this is given for clientProcessID: The process id of the application calling sql server. Does this mean, that a particular application, say excel would have the same clientprocessid at that time or is it different?
I could not locate the correct page which explains all the fields.
July 6, 2010 at 5:18 am
balasach82 (7/6/2010)
In Profiler, this is given for clientProcessID: The process id of the application calling sql server. Does this mean, that a particular application, say excel would have the same clientprocessid at that time or is it different?
It's the processID that you see if you open task manager on a client machine. Different every time the application runs.
I could not locate the correct page which explains all the fields.
The link I gave you lists each event that profiler can trace. Each event then lists the columns that event populates and what the values they'll have. I don't think there's a master-list of columns because for some of them their values have different meanings for different events.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2010 at 6:27 am
Gail's already pointed you to the best resource, Books Online, but the second best resource on the general topic of Trace, Trace Events and the Profiler is Brad Magehee's book.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply