Deadlock trace

I'm currently having some deadlock issues in my production database, and I
need to trace them to investigate further. I have read on
www.sql-server-performance.com that I can run a create trace wizard and use
the "Identify The Cause of a Deadlock" trace. However I haven't been able to
find it...? How do I find the wizards in profiler...? I use sql server 2000
standard edition...
Henning FrettemLook under the Locks event class in Profiler. There isn't a wizard for doing
it...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Henning Frettem" <henninggf@.frisurf.no> wrote in message
news:ytBKb.17195$%J2.2675@.news-binary.blueyonder.co.uk...
> I'm currently having some deadlock issues in my production database, and I
> need to trace them to investigate further. I have read on
> www.sql-server-performance.com that I can run a create trace wizard and
use
> the "Identify The Cause of a Deadlock" trace. However I haven't been able
to
> find it...? How do I find the wizards in profiler...? I use sql server
2000
> standard edition...
> Henning Frettem
>|||The reference at www.sql-server-performance.com was for SQL Server 7, which
has a CREATE TRACE WIZARD. There are trace templates in SQL Server 2000,
but not a wizard, and none of the predefined templates are specifically for
tracking down deadlock.
In the Books Online page called "SQL Profiler Scenarios", it describes how
to use profiler to trace deadlocks.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Henning Frettem" <henninggf@.frisurf.no> wrote in message
news:ytBKb.17195$%J2.2675@.news-binary.blueyonder.co.uk...
> I'm currently having some deadlock issues in my production database, and I
> need to trace them to investigate further. I have read on
> www.sql-server-performance.com that I can run a create trace wizard and
use
> the "Identify The Cause of a Deadlock" trace. However I haven't been able
to
> find it...? How do I find the wizards in profiler...? I use sql server
2000
> standard edition...
> Henning Frettem
>|||> In the Books Online page called "SQL Profiler Scenarios", it describes how
> to use profiler to trace deadlocks.
Excellent, thanx alot... :)
Henning Frettem