October 3, 2012 at 3:49 am
Hi all,
Is it possible to use TF 1222 and export the data from the eventlog into the graph that you get with profiler?
I need to get the data to a 3rd party and im reluctant to turn on profiler/server side trace to get info i already have..
Regards
October 3, 2012 at 6:24 am
Absolutely. Save the trace ouput to a file, then open the file in profiler. Find the DL event in the listing of events, right click on the event and select 'Extract Event Data'. You get the usual windows event dialog, and it will save a file with the name you give it with an xdl extension.
You can then open that xdl file in SSMS, it has all of the graphical info, tool tips, etc.
October 3, 2012 at 6:26 am
OK, I misread your question - I have a server side trace that gathers this info. why the reluctance for a SST? Mine gathers DL info and that is it. Very lightweight.
October 3, 2012 at 6:37 am
On SQL Server 2008 you don't need a trace and you don't event need the traceflag. Deadlock graphs are written automatically to the system health extended events session.
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
October 3, 2012 at 6:40 am
Hi,
I was just hoping to be able to get it from the event log since i already have the xml output and text.. We run SQL Monitor that uses the text logging but doesnt show the actual t-sql code (unless you run a server side trace from within sql mon) . and i enabled the xml logging hoping to get it into the graph form .
It just seemed counter productive to have so many things doing the same thing..
If there's no way to get out the xml from the event log then it does seem a lot easier to just run a server side trace i agree. then turn off the trace flags for xml and leave the text on just get easy alerts from sql monitor
Thanks
October 3, 2012 at 7:19 am
Hi Gail,
i just found a Jon K script that im guessing.. no guessing it says it right there.. ill stop being blind!.. it throw out a very nice table of xml for me containing all the deadlock info..
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
Extended Events ftw!
October 3, 2012 at 7:40 pm
n00bDBA (10/3/2012)
Hi Gail,i just found a Jon K script that im guessing.. no guessing it says it right there.. ill stop being blind!.. it throw out a very nice table of xml for me containing all the deadlock info..
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
Extended Events ftw!
Let's make that link a little easier to access:
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
Too bad it seems to be dead for me.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
October 4, 2012 at 3:12 am
dwain.c (10/3/2012)
Let's make that link a little easier to access:http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
Too bad it seems to be dead for me.
That's because you put the [/url] on a new line.
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
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 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply