Post reply

SQL Server Alerts

  • November 19, 2008 at 10:27 am

    #196553

    Hi all

    I don't know if this kind of "warning" create in SQL Server Agents impact of performance....like Profiler or DTA (Database tuning advisor) 'cause those catch a trace....

    let me know...Alen

    ________

    EXEC msdb.dbo.sp_add_alert @name=N'Lock Waits/sec',

    @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|Lock Waits/sec|_Total|>|2',

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

  • November 20, 2008 at 3:36 am

    #900949

    I'm not sure but I think it will generate an overhead similar to Windows Performance Monitor. But it can also depend on the number of alerts that are generated.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply