Red Gate forums :: View topic - Reading deadlocks in SQLMonitor query
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Reading deadlocks in SQLMonitor query

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
staggerlee011



Joined: 17 Jan 2012
Posts: 9

PostPosted: Wed Oct 03, 2012 10:24 am    Post subject: Reading deadlocks in SQLMonitor query Reply with quote

Hi,

we have started getting deadlocks in an application and has brought up a couple of questions i was hoping someone could help with.

I can see traceflag 1204 is on which puts deadlock text into the event log. Did SQL Monitor enable the traceflag? Its possible someone else in the team did and didnt mention it.

In SQLMonitor i cant see the actual T-SQL for either process. Is it possible to get this from SQLMonitor?

If the SQLMonitor does use the traceflag 1204 is it possible to use the XML output instead 1222 and get the grapth put into sqlmon?

Thanks for any help

Regards
S
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Wed Oct 03, 2012 11:49 am    Post subject: Reply with quote

SQL Monitor does enable traceflag 1204 yes. As a monitoring product, we have a relatively low impact on servers but that trace flag is essential so that we can detect deadlocks.

Regarding the T-SQL for the processes, it's possible from within SQL Monitor to enable a server-side trace. This is done via Configuration > Trace. After enabling this on the relevant server, future deadlock alerts should show trace information in the Performance Data section of the alert details page (in a tab named "SQL processes / Profiler trace"). Click the relevant SPID and trace should be displayed. Note that running the trace impacts the monitored server so it should ideally be disabled once you have seen enough information.

We have an enhancement request (SRP-4176) to move from traceflag 1204 to 1222. 1204 is required for SQL Server 2000 support but we are considering the option of using 1222 on more recent SQL Server versions.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
staggerlee011



Joined: 17 Jan 2012
Posts: 9

PostPosted: Wed Oct 03, 2012 11:58 am    Post subject: Reply with quote

Hi Chris,

Thanks for the quick reply..

Regards
S
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group