Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 Standard Trace Template Expand / Collapse
Author
Message
Posted Tuesday, July 6, 2010 3:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 389, Visits: 959
In SQL 2005 Standard Trace Template, are there any documentation explanining each fields ( for ex: clientprocessid )
Post #947776
Posted Tuesday, July 6, 2010 3:47 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 42,450, Visits: 35,505
Books Online?

http://msdn.microsoft.com/en-us/library/ms175481%28SQL.90%29.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #947787
Posted Tuesday, July 6, 2010 4:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 389, Visits: 959
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.
Post #947802
Posted Tuesday, July 6, 2010 5:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 42,450, Visits: 35,505
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #947820
Posted Tuesday, July 6, 2010 6:27 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:11 PM
Points: 15,517, Visits: 27,898
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #947869
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse