Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Deadlock Priority

Author  Topic 

zamdrist
Starting Member

2 Posts

Posted - 2010-04-14 : 14:40:28
MS SQL Server 2005 SP3.

Under 'normal' (is there such a thing?) conditions, I shouldn't have to mess with the DeadLock_Priority setting I presume. If I wanted to know what it is current, how would I look that value up? Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-14 : 15:08:35
I don't know how to query for it, but the default is NORMAL so if you haven't changed it for a particular session, then it is NORMAL. The setting is NORMAL for each new session.

I have never changed it from NORMAL.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -