Advisory Conditions: October 2017 Pack - SentryOne Team Blog

Advisory Conditions: October 2017 Pack

Please note that this blog has been updated to include a link to our 11.2 product release tour.

We've recently released a new pack of Advisory Conditions. This pack includes a handful (or two) of new conditions and approximately a bushel of updated conditions. (It's October and for that reason I'm talking about this pack like I've harvested the conditions for you. Which, I kind of did.)

New Advisory Conditions

The new Advisory Conditions are mostly for Service Broker, a few for Tintri, and one for Tempdb. Please check out the actual conditions for complete descriptions and links to more in-depth information.

New Advisory Condition Notes Settings
Service Broker – Activation Errors Occurred Checks for Service Broker procedures exiting due to errors. Service Broker - Activation Errors Occurred
Service Broker – Login Connection Error Checks sys.dm_broker_connections for a login_state of 13, which indicates a connection error. Service Broker - Login Connection Error
Service Broker – 'Poison Message Handling' Disabled Checks sys.service_queues to see if is_poison_message_handling_enabled is false. Service Broker - 'Poison Message Handling' Disabled
Service Broker – Queues with Issues Checks sys.service_queues for entries that have an activation_procedure, but is_activation_enabled, is_receive_enabled, or is_enqueue_enabled is disabled. Service Broker - Queues with Issues
Service Broker – Task Limit Reached / Sec Checks for Task Limit Reached/sec Total counter >= 1. Service Broker - Task Limit Reached / Sec
Service Broker – Transmission Queue Errors Counts the number of messages in sys.transmission_queue where is_conversation_error is true. Service Broker - Transmission Queue Errors
Tempdb Large Version Store Checks for a tempdb version store that is greater than 100,000 KB. Tempdb Large Version Store
Tintri High Datastore Throttle Latency Checks for Tintri Datastore : Throttle Latency (ms) > 10. Tintri High Datastore Throttle Latency
Tintri High vDisk Throttle Latency Checks for Tintri Virtual Disk : Throttle Latency (ms) Any > 10. Tintri High vDisk Throttle Latency
Tintri High VM Throttle Latency Checks for Tintri Virtual Machine : Throttle Latency (ms) Any > 10. Tintri High VM Throttle Latency

If any of these conditions do not pertain to your environment, please remember that you can disable any Advisory Condition that isn't helpful for your system. You can also copy and modify any of our published Advisory Conditions to tune them for your specific needs. Don't forget about setting up the desired actions for when conditions are met.

Updated Advisory Conditions

The updated Advisory Conditions mostly had minor updates, mainly to names and descriptions.

Updated Advisory Condition Notes
Availability Replicas Hosted on Same Virtual Host Updated URL in description.
Availability Replicas with Disks in Same Datastore Updated URL in description.
CPU Schedulers Visible Offline Status Added 'Windows: CPU Usage' to Highlight on Dashboard Chart. Added additional URL to description.
CPU Unused Schedulers Added 'Windows: CPU Usage' to Highlight on Dashboard Chart.
High Ad Hoc Query Plans Improved the description.
High Compiles Added 'SQL Server: Activity' to Highlight on Dashboard Chart.
High Recompiles Added 'SQL Server: Activity' and 'SQL Server: Cache Hit Ratios' to Highlight on Dashboard Chart.
High Redo Completion Time Added Minimum SQL Server Version 11.0. This condition may be new to your environment if not previously downloaded.
Incorrect Compatibility Level Updated description to reference SentryOne instead of SQL Sentry.
Long Running Open Transactions Updated query to include T-SQL text from the open transaction. Updated the description.
Page Verification Check Updated description to reference SentryOne instead of SQL Sentry.
SentryOne Monitoring Service Offline Updated name and description to reference SentryOne instead of SQL Sentry.
SQL File Auto-growth Disabled Updated description to reference SentryOne instead of SQL Sentry.
SQL File Auto-growth Exceeds Free Space Updated description to reference SentryOne instead of SQL Sentry.
Suspect Pages – Active Corrupt Pages Updated URL in description.
Suspect Pages – High Row Count Updated URL in description.
Tempdb Data Files Fixed SQL Server Query for case-sensitive collations.
Tempdb Unequal File Sizes Updated URL in description.
Tempdb/CPU Configuration Warning > 8 CPUs Updated URL in description.
Downloading the Pack

You can download the pack from the SentryOne client.* You should receive a notification in the client about the availability of the new pack this week. However, you can access it at any time from the menu: Tools –> Download Latest Advisory Conditions Pack.

Download Latest Advisory Conditions Pack

*Unless you are on a really, really old version of SentryOne that doesn't have Advisory Conditions. I believe they were introduced in Version 8.

Summary

There are new and improved Advisory Conditions available for SentryOne.

  • Download the pack
  • Check out the Advisory Conditions
  • Customize or disable if necessary
  • Set up the desired alerts and actions

  • Don't have SentryOne? No problem. You can get a free trial here to check out the Advisory Conditions and so much more.

    Learn More about  SentryOne 11.2

    Comments ( 0 )

      Leave A Comment

      Your email address will not be published.