We upgraded our SQL Server from 2008 R2 to 2014.
I want to add a custom warning.
USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name = N'MAN more than 1000', @enabled = 1, @delay_between_responses = 0, @include_event_description_in = 1, @performance_condition = N'Replication Dist.|Dist:Delivered Cmds/sec|MyFancyReplication|>|1000', @job_id = N'00000000-0000-0000-0000-000000000000' GO
This has worked with SQL Server 2008 R2.
When I want to add this Warning, but all I get is this error (it's translated, because my original is German)
A performance condition must be formatted as:
‘object_name|counter_name|instance_name|comparator( or < or =)|numeric value'.
Did you recognize the missing
> in the error message?
Why can't I add my custom warning?