Re: identifying deadlock conditions

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 06:44:29 +0530

Hi,

Is there any other way to enable the Trace flag 1204

1. Go to control panel -- Admin tools -- Services
2. Double click MSSQL server service
3. In the General Tab, stop the service
4. Start parameters give "-T1204 "
5. Start the SQL service

Note:- You can also give the same usign SQL server enterprise manager
"Startup options"

Our application reported deadlock conditions but when i searched for
"Deadlock" event in the trace file, I did
not find any deadlock events being captured. Any idea why?

I have set the deadlock event and was able to view in profiler when dead
lock occurs. Not sure.

Thanks
Hari
MCDBA

"mitra fatholahi" <mitra928@hotmail.com> wrote in message
news:17f7801c449c0$2d6d9000$a501280a@phx.gbl...
> Hi all,
>
> In SQL Server 2000, we used the SQL Profiler Lock event
> to capture deadlock conditions. To eliminate the SQL
> Profiler to capture a lot of information, i specified the
> criteria for determining which events to capturs.
>
> Our application reported deadlock conditions but when i
> searched for "Deadlock" event in the trace file, I did
> not find any deadlock events being captured. Any idea why?
>
> I read about the Trace Flag 1204 for troublshooting
> Deadlocks on SQL Server Books Online. Books Online talks
> about enabling the trace by starting SQL Server 2000 in
> command prompt. I am not comfortable with starting SQL
> Server in command prompt. Is there any other way to
> enable the Trace flag 1204. And does any one have a good
> suggestion for how to troublshoot deadlock conditions. I
> am new to troubleshooting performance and i appreciate
> anyone can help me out.
>
> Thank you,
>
> Mitra

Relevant Pages

  • Re: trace 1204
    ... you can turn on trace flag 3605 so that the deadlock ... diagnostics are written to the SQL Server error log. ...
    (microsoft.public.sqlserver.programming)
  • Re: How can I create report after 1024 flag detect a deadlock?
    ... The trace flag to report deadlock is 1204, ... automatically the deadlock information will send to ... How can I create the report what the SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: -T3608 -T4022
    ... SQL Server 2000. ... trace flag 3608 skips automatic recovery for all databases except the ... procedures will be bypassed during startup. ... 4022 in SQL Server Books Online in the topic CREATE PROCEDURE under the ...
    (microsoft.public.sqlserver.clients)
  • Re: Trace Flag 1204
    ... OK Greg - so, more specifically, I have a test system that, every now and ... However, it doesn't give the entire output that trace flag 1204 would give, ... 1204, likely for some time, until this deadlock occurs, in order to find out ... I am wondering specifically if the performance of the SQL Server will ...
    (microsoft.public.sqlserver.server)
  • Re: Trace Flag 1204
    ... Trace flag 1204 is used to troubleshoot deadlock. ... Generally I would use it to resolve ... It surely has some impact on the SQL Server performance. ...
    (microsoft.public.sqlserver.server)