Hello SQL-Friends,
yesterday we upgrade our SQL-Server to 2014. Today I miss a warning for replication.
However, I Have the sp_add_alert Script, looks like this:
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
When I execute this, I get this warning (translated because the 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 "greater than" in the error message? There is just " " than or and so on...
I've checked the MSDN for an answer. (http://msdn.microsoft.com/en-us/library/ms189531.aspx)
The @performance_condition can be >, < or =
So, whats the problem?
Best Regards
Björn