June 6, 2008 at 9:23 am
I wanted to Create Server Traces using profiler in 2005. What all events
to be selected. I am unable to trace out the problem with my Databases.
When i execute stored procedures individually of a database, it runs well. So i thought of creating Traces on Server.
Thanks for all those who will be answering me.
June 6, 2008 at 12:50 pm
Without at least some clue as to what you're trying to resolve, I'm kind of at a loss as to what to suggest. If you say what kind of problems you're trying to track down, we can probably suggest some traces to use.
- 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
June 6, 2008 at 1:24 pm
I wanted to Find out what actually is causing server running slow.
When we tested Stored Procedures individually ,they are fine.
May be problem with Batch jobs or any other maintenance plans.
Thats the reason why i wanted to create Server Traces.
June 9, 2008 at 9:52 am
There's a default template. Start with that.
- 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
June 9, 2008 at 12:54 pm
Set up a profiler trace with the events you want. The default template is mostly good (though you may want to check TextData for either RPC completed or SQLBatch Completed. For 1 of them it's unticked by default.
You can get profiler to generate the script for you. Saves a bunch of typing.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply