Deadlocks increasing

I have setup a SQL alert that email's me if deadlocks occur. I recently
started getting flooded with alot of emails(see below) with deadlocks. The
current value does not drop back down, it remains at 4 until I restart the
SQL server. This has happened once in the past before, about 3 weeks ago.
We fixed it by restarting the server. I have DBCC OPENTRAN on all databases
and there are no active transaction open. Perfmon shows that I have 0
deadlocks but still I get these emails. Turning trace 1204 also shows me 0
deadlocks occurring. Can someone help me.
Tim
----
--
DATE/TIME: 10/13/2004 10:24:02 AM
DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
(instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
threshold of 3.00 (the current value is 4.00).
COMMENT: (None)
JOB RUN: (None)More information to supply:
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>|||More information:
select * from sysperfinfo where counter_name = 'Number of Deadlocks/sec'
object_name counter_name instance_name cntr_value cntr_type
MSSQL$INST01:Locks Number of Deadlocks/sec Extent 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Key 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Page 4 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Table 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec RID 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec Database 0 272696320
MSSQL$INST01:Locks Number of Deadlocks/sec _Total 4 272696320
I have 4 page deadlocks that will not release or reset. SP_LOCK shows no
current page locks.
Tim
"Tim" <Tim@.NOSpam.com> wrote in message
news:#0H6MnTsEHA.1216@.TK2MSFTNGP10.phx.gbl...
> I have setup a SQL alert that email's me if deadlocks occur. I recently
> started getting flooded with alot of emails(see below) with deadlocks.
The
> current value does not drop back down, it remains at 4 until I restart the
> SQL server. This has happened once in the past before, about 3 weeks ago.
> We fixed it by restarting the server. I have DBCC OPENTRAN on all
databases
> and there are no active transaction open. Perfmon shows that I have 0
> deadlocks but still I get these emails. Turning trace 1204 also shows me
0
> deadlocks occurring. Can someone help me.
> Tim
> ----
--
> --
> DATE/TIME: 10/13/2004 10:24:02 AM
> DESCRIPTION: The SQL Server performance counter 'Number of Deadlocks/sec'
> (instance '_Total') of object 'MSSQL$INST01:Locks' is now above the
> threshold of 3.00 (the current value is 4.00).
> COMMENT: (None)
> JOB RUN: (None)
>|||Hi Tim,
To troubleshoot this issue, there would be several other things to try and
to check. However, as this is an issue that happens randomly, we may spend
extensive time to narrow it down since random issues are always hard to
troubleshoot. I would like to recommend that you contact Microsoft Product
Support Services and open a support incident and work with a dedicated
Support Professional.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
For now, from your descriptions, I understood that something were blocked
more frequently than you had exptected. Have I understood you? Correct me
if I was wrong.
Based on my scope, you'd better follow the instrunctions in KB below to
collect more information and what cause the block. Blocking could becaused
by various factors
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/kb/224453/en-us
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!