In my last blog post, Custom Conditions : A Logical Choice, I mentioned that a new Custom Conditions Pack would soon be released. This post is to announce that those promised conditions have been published!
There are nearly two dozen new conditions available, covering numerous important areas such as Suspect Pages, Tempdb, and VMware. Click on any of the conditions below to learn more about what they do:
- ‘Common Criteria Compliance’ Enabled
- ‘Cost Threshold of Parallelism’ Changed
- High Context Switches – Warning
- High Number of Failed Logins
- ‘High Performance’ Power Plan not Enabled
- Hyper-V High vCPU Wait Time
- Long Running Open Transactions
- Sleeping Sessions with Old Open Transactions
- SQL File Auto-growth Disabled
- SQL File Auto-growth Exceeds Free Space
- SQL Sentry Monitoring Service Offline
- Suspect Pages – Active Corrupt Pages
- Suspect Pages – High Row Count
- Suspect Pages – Increase in Fixed Pages
- Tempdb Unequal File Sizes
- Tempdb/CPU Configuration Warning
- Tempdb/CPU Configuration Warning > 8 CPUs
- Trace Flags Number Turned On Changed
- Trace Flags Total Number Changed
- VMware High Ballooning
- VMware High Co-Stop %
- VMware High Ready Time % per vCPU
- VMware High Ready Time % per vCPU – Warning
If you did not receive an alert about the latest Custom Conditions Pack, you may have the automatic check turned off in your user preferences (the automatic check occurs once daily). You can change this setting via Tools –> User Preferences –> Updates:
Figure 1 : showing User Preferences for Updates
You can also manually download the pack by selecting Tools –> Download Latest Custom Conditions Pack:
Figure 2 : showing option to Download Latest Custom Conditions Pack
Once the Custom Conditions have been downloaded, don’t forget to apply the desired actions to them.
It won’t be long before we release another new pack of exciting conditions. If you have ideas for new conditions, please leave a comment about them. I’m sure everyone reading this can each think of a unique and helpful condition to create.
Melissa 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.