October 12, 2011 at 8:02 am
Hi Team,
I m Tracing deadlocks,Errorlogs,blockings this output dump into the one table.
It is very simple to tracing using profiler. but i m looking with the script i have to put it into one stored procedure i have to Trace this sp every two seconds can you any body please suggest me with good script plz..
Really appriciated those guys.
Tx
October 12, 2011 at 10:39 am
For deadlocks you are better off using trace flag 1222 which writes them to the event log.
You can use profiler to define a trace and then export the definition as a script to setup a server-side trace that you can run indefinitely. There is a short video on how to do this on SQLShare.com, http://sqlshare.com/saving-a-trace-definition-in-sql-server-profiler_449.aspx.
You should also research extended events for this.
Jack Corbett
Consultant - Straight Path Solutions
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
October 12, 2011 at 11:05 am
Hi Team,
My Requrement was changed. here
Right now i m tracing the new things Errorlog, Exceptions, User Error Messages
Can you people plz suggest me with good script. For Tracing and This Output was stored into one Table.
Thanks for your reply..
Tx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply