It’s spring time; time to tune the SQL carb!
Carbs are way less easy to find these days, but I’ve been busy tuning the SQL agnostic pack (MSSQL on Windows).
Tuning the SQL Agnostic pack would be far less successful without expert help. My thanks to Brandon Pires – MCS SQL Consultant who helped provide a SQL DBA perspective. Brandon’s LinkedIn profile
Always grab an expert, and for SQL, it’s a DBA. If you’re new to SCOM, most product teams provide their management packs. SCOM PFE’s build addendum packs to improve a pack (from our perspective). Addendum packs make the a pack stronger, for an improved customer experience. I’m not complaining at what the pack delivers. The SQL Team is awesome for taking user feedback and making improvements quarterly!
Initially this journey started out with Tim McFadden disabling the duplicate rules/monitors in the SQL MP’s (here).
After talking with Tim and Kevin H, I set out to clean up the SQL version specific packs to remove bloat by creating the version specific OFF packs. The OFF packs disabled the plethora of SQL performance counters (see MP bloat blog here).
With the SQL Agnostic packs (thank God!), I wanted to deliver an addendum pack to tune the SQL alerts/health for what SQL PFE/Consultants recommended for an improved out of the box experience (OoBE).
MP Version history
v220.127.116.11 24 Feb 2020 Override to enable SQL Monitoring
v18.104.22.168 24 Feb 2020 Override pack cleanup to human readable format
v22.214.171.124 2 Mar 2020 Overrides for severities and SQL CPU samples
v126.96.36.199 2 Mar 2020 Overrides for SQL rules for warning
v188.8.131.52 4 Mar 2020 Completed overrides for SQL warning rules
v184.108.40.206 1 Apr 2020 Updated rules for backup failures when customer uses Netbackup vs. SQL agent/scheduled tasks
v220.127.116.11 9 Apr 2020 Created groups for seed discovery Test/Dev and Prod; excluded EXPRESS, disabled Securables monitor
v18.104.22.168 15 Apr 2020 Updated pack name to include ‘SQL Server’.
Updated AddendumGroupGUIDUpdate to include RegEx pattern replace
AddendumGroupGUIDUpdate will version pack to v22.214.171.124 for group GUID and regex changes
Please feel free to download the zip file, which includes the XLS for review of what was updated.
The Agnostic OFF Pack to turn off the performance rules (found here)
The old SQL version specific OFF packs for the performance counters can be found here.