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

Trace Expand / Collapse
Author
Message
Posted Tuesday, February 2, 2010 10:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650


Hi

I'mtrying to find out the exact difference between batch-level trace and a statement-level trace in sql server.

Can any one helpmeout inthis regard.


Post #858092
Posted Tuesday, February 2, 2010 2:25 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:04 AM
Points: 1,030, Visits: 2,795
sandhyarao49 (2/2/2010)


Hi

I'mtrying to find out the exact difference between batch-level trace and a statement-level trace in sql server.

Can any one helpmeout inthis regard.




I'm not sure if I'm explaining this clearly

But Batch events relate to the whole batch being executed..for example the BatchCompleted event reports information on the batch start time, end time, duration, reads, writes etc. If the batch is astored proc call all you will get is one entry when the batch completes. The only data in the text data column will be the call to the stored proc. If that stored proc is slow and you tuning it and you want to see which statements inside the proc are performing poorly then you need to dig a bit deep into the proc and look at the exact TSQL statements that make up the proc so...

Stmtcompleted, if you have that event in the same trace, if said Stored Proc is made up several TSQL statements each statement will recorded in the trace separately giving a breakdown of each one.

HTH



Gethyn Ellis

gethynellis.com
Post #858259
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse