Prev: EssBase Architect with OBIEE - Chicago,IL
Next: SAP ABAP LEAD - Syracuse,NY
From: xo on 13 May 2010 14:22
Hi -

I have questions on deadlock tracing and hope someone can help.

I enabled deadlock trace with dbcc traceon (1222, 1204, -1), and I
want to redirect the result to a log/trace file away from the sql
server error log.

Is there a way and how should it be done? Does it require an instance/
server bounce?

Thanks in advance.
From: Erland Sommarskog on 13 May 2010 16:16
xo (xo5555ox(a)gmail.com) writes:
> I have questions on deadlock tracing and hope someone can help.
>
> I enabled deadlock trace with dbcc traceon (1222, 1204, -1), and I
> want to redirect the result to a log/trace file away from the sql
> server error log.

As far as I know this is not possible per se. However, you can set up a
server side trace that include Deadlock Graph as the single event.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: EssBase Architect with OBIEE - Chicago,IL
Next: SAP ABAP LEAD - Syracuse,NY