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
v18.104.22.168 24 Feb 2020 Override to enable SQL Monitoring
v22.214.171.124 24 Feb 2020 Override pack cleanup to human readable format
v126.96.36.199 2 Mar 2020 Overrides for severities and SQL CPU samples
v188.8.131.52 2 Mar 2020 Overrides for SQL rules for warning
v184.108.40.206 4 Mar 2020 Completed overrides for SQL warning rules
v220.127.116.11 1 Apr 2020 Updated rules for backup failures when customer uses Netbackup vs. SQL agent/scheduled tasks
v18.104.22.168 9 Apr 2020 Created groups for seed discovery Test/Dev and Prod; excluded EXPRESS, disabled Securables monitor
v22.214.171.124 15 Apr 2020 Updated pack name to include ‘SQL Server’.
Updated AddendumGroupGUIDUpdate to include RegEx pattern replace
AddendumGroupGUIDUpdate will version pack to v126.96.36.199 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.