Response Rulesets control how often actions are taken in response to conditions. Note: Consider applying a Response Rulesetto any action you configure with the SQL Server: Blocking SQL condition. The OCM condition is useful in narrowing the notifications you see concerning blocking. Configure an action in response to the SQL Server: Blocking SQL: Output Content Match (OCM) condition. The SQL Server: Blocking SQL condition occurs each time a block is collected, and therefore has a direct correlation to the Blocking SQL Source Collection settings. For more information about retention, see the Data Capacity Planning topic.Ĭonfigure actions in response to Blocking SQL conditions. This is controlled with the Keep Performance History For setting found on the Storage tab of Global Settings ( Navigator pane > Configuration > Global Settings > Storage tab). Change this maximum length in the Monitoring Service Settings ( Navigator pane > Configuration > Global Settings > Monitoring Service Settings > Advanced tab > Query Collection Maximum Text Length).īy default, Performance Analysis Blocking SQL, Top SQL, and Deadlock data is retained for 15 days. Change the Minimum Block Duration setting to your desired value it's saved automatically.īy default, SQL text data length for captured events is limited to 10,000 characters. ![]()
0 Comments
Leave a Reply. |