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'