New
Score6
Would suggest to re-create the message definition of the sqlserver checkpoint: long_queries, so that the alarms will trigger the alert along with the database name from which it is triggering. The latest probe version(5.30) running currently does not have any option to add the database name in the checkpoint - long_queries.
Alert Ex:
Profile pr-sqlprd-01(172.25.104.39)pr-sqlprd-01, instance pr-sqlprd-01, user 897 (CDSrvSQL) runs query for 813.55 sec, sql text: SELECT StatMan([SC0]) FROM (SELECT TOP 100 PERCENT [Properties] AS [SC0] FROM [dbo].[SavesetProperty] WITH (READUNCOMMITTED) ORDER BY [SC0] ) AS _MS_UPDSTATS_TBL
Anurupa Which product is this idea for? please edit your idea, scroll to bottom and select the product. Your idea will get more visibility in doing this. Thanks!