Thursday, March 29, 2012

Deadlocks in error log

In the past when a deadlock occurred, it was written into
the SQL Server error logs. I thought this was SQL Server
wide. However, now I'm in a new company and when I created
a deadlock, it wasn't written into the SQL Error logs.
Am I missing a setting somewhere?
Please advise
Thanks
FredHi,
This level of error logging is not by default. Check BOL
on DBCC TRACEON.
Brig
>--Original Message--
>In the past when a deadlock occurred, it was written
into
>the SQL Server error logs. I thought this was SQL Server
>wide. However, now I'm in a new company and when I
created
>a deadlock, it wasn't written into the SQL Error logs.
>Am I missing a setting somewhere?
>Please advise
>Thanks
>Fred
>.
>

No comments:

Post a Comment