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.)
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.
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.
Melissa (@MelikaNoKaOi) is the Product Education Manager at SentryOne. Melissa has over a decade of experience with SQL Server through software performance and scalability testing, analysis and research projects, application development, and technical support.