September 26, 2005 at 12:36 pm
Hi,
We got some blocking/dead lock issues in our servers. We have implemented once stored procedure, which will report on the blocking issues. We are getting the below errors/information
DBCC INPUTBUFFER FOR SPID 662
RPC Event
0
dbo.BFSDiagnosticLogDetailAdd;1
DBCC INPUTBUFFER FOR SPID 677
Language Event
0
IF @@TRANCOUNT > 0 COMMIT TRAN
do you guys have any idea about the above. I appreciate your help.
with smiles
Santhosh
September 26, 2005 at 12:56 pm
Blocking locks and deadlocks are different things. If you are getting deadlocks, you can enable the trace flags 1204, 1205 and 3605 to get more information - that way the deadlock trace files will give you much more information on what actually transpired in that deadlock.
If you are troubleshooting blocking locks, then look up this script from PSS:
http://support.microsoft.com/default.aspx/kb/271509/EN-US
and use it to interpret your results. The statements that you have given above are just input buffer information from two spids. Take a look at that "BFSDiagnosticLogDetailAdd" object definition to see what it is doing and also at the same time spend time to record the output from the above PSS procedure to see what applications are involved and what kind of locks are being taken.
Hth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply