Loading Trace Files To A Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Loading Trace Files To A Table

16 posts, Page 2 of 2

««1 2

Loading Trace Files To A Table

Rate Topic

Display Mode

Topic Options

Author

Message

chinn

Posted Thursday, July 30, 2009 7:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:32 AM
Points: 127, Visits: 490

Thanks...Very Much!

I got an idea from your previous post...Thanks for you help!

Post #762381

chinn

Posted Friday, July 31, 2009 12:28 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:32 AM
Points: 127, Visits: 490

Guys,
One quick question...
When running Server Side Tracing...if we restart sql server ..Do i need to just start the existing trace
or
Recreate the Trace

In other words..will the trace be stopped or closed(deletes the definition)

Thanks,

Post #763316

Jack Corbett

Posted Friday, July 31, 2009 12:36 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 10,571, Visits: 11,871

The trace definition is deleted. You will need to recreate it and restart it. If this is something you always want running you may want to encapsulate it in a stored procedure and mark the stored procedure for startup. Here's a link for that. Or you can put it in a job that runs on startup.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #763319

GSquared

Posted Friday, July 31, 2009 12:36 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

You'll have to re-create it. I set them to do that in an auto-start proc that fires off when the SQL service starts.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #763320

chinn

Posted Friday, July 31, 2009 1:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:32 AM
Points: 127, Visits: 490

Thanks Very Much For You Prompt replies.

Thanks Again...

Post #763351

Prakash.Bhojegowda

Posted Monday, January 07, 2013 8:34 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 10:30 AM
Points: 33, Visits: 490

Hi chinn,

I am looking for a similar solution that you were looking for. Could you let me know how you were able to accomplish the automation of loading trace files to a table?

Thanks!

Post #1403657

« Prev Topic | Next Topic »

16 posts, Page 2 of 2

««1 2

Permissions