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.)
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 - Login Connection Error | Checks sys.dm_broker_connections for a login_state of 13, which indicates a connection error. |  |
| Service Broker - 'Poison Message Handling' Disabled | Checks sys.service_queues to see if is_poison_message_handling_enabled is false. |  |
| 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 - Task Limit Reached / Sec | Checks for Task Limit Reached/sec Total counter >= 1. |  |
| Service Broker - Transmission Queue Errors | Counts the number of messages in sys.transmission_queue where is_conversation_error is true. |  |
| Tempdb Large Version Store | Checks for a tempdb version store that is greater than 100,000 KB. |  |
| Tintri High Datastore Throttle Latency | Checks for Tintri Datastore : Throttle Latency (ms) > 10. |  |
| Tintri High vDisk Throttle Latency | Checks for Tintri Virtual Disk : Throttle Latency (ms) Any > 10. |  |
| Tintri High VM Throttle Latency | Checks for Tintri Virtual Machine : Throttle Latency (ms) Any > 10. |  |
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.
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. |
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.
*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.
There are new and improved Advisory Conditions available for SentryOne.
Don't have SentryOne? No problem. You can get a free trial here to check out the Advisory Conditions and so much more.
Facebook
Linkedin
Twitter
Comments