Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Carolyn Richardson What do you do with a new SQL Server? RE: What do you do with a new SQL Server?

  • June 12, 2008 at 10:50 am

    #827992

    Try a different alert, I'll be honest I have been lucky enough not to come across any deadlocks in SQL Server 2005 databases I've supported - things have been looking up, the deadlock event was set up and taken from a SQL Server 2000 script.

    USE [msdb]

    GO

    /****** Object: Alert [Deadlock] Script Date: 06/12/2008 17:46:22 ******/

    EXEC msdb.dbo.sp_add_alert @name=N'Deadlock',

    @message_id=0,

    @severity=0,

    @enabled=1,

    @delay_between_responses=0,

    @include_event_description_in=1,

    @category_name=N'[Uncategorized]',

    @performance_condition=N'SQLServer:Locks|Number of Deadlocks/sec|Database|>|1',

    @job_id=N'00000000-0000-0000-0000-000000000000'

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]