Question: Profiler trace!!!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Question: Profiler trace!!!

Question: Profiler trace!!!

Rate Topic

Display Mode

Topic Options

Author

Message

JMSM

Posted Wednesday, March 03, 2010 4:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 185, Visits: 759

Hello again,

As i was reading in a fantástic link send by Gail Shaw, i put a profiler running to catch all the queries in a period o time but, now i've got more questions about it.

I attach a file Aux-Profiler.xlsx where i've inserted all the data that becomes from one *.trc file:

Questions:
1st How can i see what event is the one in the first raw as the procedure name appears NULL

2nd Am i doing the conversion to minutes well?
I need to get all the info that was running more than a minute but i'm completely lost on how should i change the data used to minutes/seconds. Crying

The only diference between what i've been doing and the fabulous link (http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/)
is that when creating my table i change the field TextData from varchar(4000) to varchar(max)
I send you to the file with all the steps (Aux-Profiler-Steps.txt)

3rd I put @maxfilesize = 3000 in the profiler template (Aux-Profiler-Template.txt)
I need to know if the file will be rewrited if the file growth to 3GB (@maxfilesize) before end time?

4th Can i use any parameter that create a new file(s) when the maxfilesize will be at limit?

Thanks and regards,
JMSM Wink

Post Attachments

Aux-Profiler.xlsx (18 views, 11.99 KB)

Aux-Profiler-Steps.txt (20 views, 1.49 KB)

Aux-Profiler-Template.txt (17 views, 1.86 KB)

Post #875825

Leo Leong

Posted Friday, March 05, 2010 12:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:50 PM
Points: 106, Visits: 318

Questions:
1st How can i see what event is the one in the first raw as the procedure name appears NULL
-- You can capture EventClass column (27) in your profiler

2nd Am i doing the conversion to minutes well?
I need to get all the info that was running more than a minute but i'm completely lost on how should i change the data used to minutes/seconds. Crying

-- in SQL Server 2008, duration field stores microsecond. So, 1,000,000 = 1 second

3rd I put @maxfilesize = 3000 in the profiler template (Aux-Profiler-Template.txt)
I need to know if the file will be rewrited if the file growth to 3GB (@maxfilesize) before end time?
-- @maxfilesize = 3000 means a new trace file will be generated (automatically) when current trace file reached 3GB of size.

4th Can i use any parameter that create a new file(s) when the maxfilesize will be at limit?
-- refer 3rd. you don't need to. file name will be appended will a running number.

[/quote]

Post #877417

JMSM

Posted Friday, March 05, 2010 2:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 185, Visits: 759

Thanks a lot.

Regards,
JMSM Wink

Post #877483

« Prev Topic | Next Topic »

Permissions