{"id":6625,"date":"2020-04-15T08:40:59","date_gmt":"2020-04-15T12:40:59","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=6625"},"modified":"2020-04-15T10:35:32","modified_gmt":"2020-04-15T14:35:32","slug":"sql-on-windows-addendum-pack","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/","title":{"rendered":"SQL on Windows Addendum pack"},"content":{"rendered":"

<\/p>\n

It’s spring time; time to tune the SQL carb!<\/p>\n

 <\/p>\n

Carbs are way less easy to find these days, but I’ve been busy tuning the SQL agnostic pack (MSSQL on Windows).<\/p>\n

 <\/p>\n

Tuning the SQL Agnostic pack would be far less successful without expert help.\u00a0 My thanks to Brandon Pires – MCS SQL Consultant who helped provide a SQL DBA perspective. \u00a0 Brandon’s LinkedIn profile<\/a><\/p>\n

 <\/p>\n

Always grab an expert, and for SQL, it’s a DBA.\u00a0 If you’re new to SCOM, most product teams provide their management packs.\u00a0 SCOM PFE’s build addendum packs to improve a pack (from our perspective).\u00a0 Addendum packs make the a pack stronger, for an improved customer experience.\u00a0 I’m not complaining at what the pack delivers.\u00a0 The SQL Team is awesome for taking user feedback and making improvements quarterly!<\/p>\n

 <\/p>\n

Background:<\/strong><\/p>\n

Initially this journey started out with Tim McFadden disabling the duplicate rules\/monitors in the SQL MP’s (here<\/a>).<\/p>\n

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.\u00a0 The OFF packs disabled the plethora of SQL performance counters (see MP bloat blog here<\/a>).<\/p>\n

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).<\/p>\n

 <\/p>\n

 <\/p>\n

MP Version history<\/strong>
\nv1.0.0.0 24 Feb 2020 Override to enable SQL Monitoring
\nv1.0.0.1 24 Feb 2020 Override pack cleanup to human readable format
\nv1.0.0.2\u00a0 2 Mar 2020 Overrides for severities and SQL CPU samples
\nv1.0.0.3\u00a0 2 Mar 2020 Overrides for SQL rules for warning
\nv1.0.0.4\u00a0 4 Mar 2020 Completed overrides for SQL warning rules<\/p>\n

v1.0.0.5\u00a0 1 Apr 2020 Updated rules for backup failures when customer uses Netbackup vs. SQL agent\/scheduled tasks<\/p>\n

v1.0.0.6\u00a0 9 Apr 2020 Created groups for seed discovery Test\/Dev and Prod; excluded EXPRESS, disabled Securables monitor<\/p>\n

v1.0.0.7 15 Apr 2020 Updated pack name to include ‘SQL Server’.<\/p>\n

Updated AddendumGroupGUIDUpdate to include RegEx pattern replace
\nAddendumGroupGUIDUpdate will version pack to v1.0.0.7 for group GUID and regex changes<\/p>\n

 <\/p>\n

 <\/p>\n

Please feel free to download the zip file, which includes the XLS for review of what was updated.<\/p>\n

My website download<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

Additional References<\/strong><\/p>\n

The Agnostic OFF Pack to turn off the performance rules (found here<\/a>)<\/p>\n

The old SQL version specific OFF packs for the performance counters can be found here<\/a>.<\/p>\n

TechNet Gallery download here<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u00a0 My thanks to Brandon Pires – MCS SQL Consultant who … Continue reading “SQL on Windows Addendum pack”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5,7],"tags":[25,243,501,244,511,512,342,410,509,508,510],"class_list":["post-6625","post","type-post","status-publish","format-standard","hentry","category-administration","category-best-practice","category-mp-management-pack","tag-addendum","tag-mp","tag-mp-author","tag-mp-authoring","tag-mssql","tag-mssql-on-windows","tag-scom","tag-sql","tag-sql-agnostic","tag-sql-monitoring","tag-sql-on-windows"],"yoast_head":"\nSQL on Windows Addendum pack - Kevin Justin's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL on Windows Addendum pack - Kevin Justin's Blog\" \/>\n<meta property=\"og:description\" content=\"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.\u00a0 My thanks to Brandon Pires – MCS SQL Consultant who … Continue reading "SQL on Windows Addendum pack"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-15T12:40:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-15T14:35:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2020\/04\/TuningCarburetor.jpg\" \/>\n<meta name=\"author\" content=\"WordPress Administrator\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"WordPress Administrator\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/\"},\"author\":{\"name\":\"WordPress Administrator\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"headline\":\"SQL on Windows Addendum pack\",\"datePublished\":\"2020-04-15T12:40:59+00:00\",\"dateModified\":\"2020-04-15T14:35:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/\"},\"wordCount\":408,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/TuningCarburetor.jpg\",\"keywords\":[\"addendum\",\"MP\",\"mp author\",\"mp authoring\",\"MSSQL\",\"MSSQL on Windows\",\"SCOM\",\"sql\",\"SQL Agnostic\",\"SQL monitoring\",\"SQL on windows\"],\"articleSection\":[\"Administration\",\"Best Practice\",\"MP Management Pack\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/\",\"name\":\"SQL on Windows Addendum pack - Kevin Justin's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/TuningCarburetor.jpg\",\"datePublished\":\"2020-04-15T12:40:59+00:00\",\"dateModified\":\"2020-04-15T14:35:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/TuningCarburetor.jpg\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/TuningCarburetor.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2020\\\/04\\\/15\\\/sql-on-windows-addendum-pack\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL on Windows Addendum pack\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\",\"name\":\"Kevin Justin's Blog\",\"description\":\"Operational monitoring tools including System Center, Azure Monitor\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\",\"name\":\"WordPress Administrator\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"caption\":\"WordPress Administrator\"},\"sameAs\":[\"https:\\\/\\\/kevinjustin.com\"],\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/author\\\/wordpress_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL on Windows Addendum pack - Kevin Justin's Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/","og_locale":"en_US","og_type":"article","og_title":"SQL on Windows Addendum pack - Kevin Justin's Blog","og_description":"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.\u00a0 My thanks to Brandon Pires – MCS SQL Consultant who … Continue reading \"SQL on Windows Addendum pack\"","og_url":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/","og_site_name":"Kevin Justin's Blog","article_published_time":"2020-04-15T12:40:59+00:00","article_modified_time":"2020-04-15T14:35:32+00:00","og_image":[{"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2020\/04\/TuningCarburetor.jpg","type":"","width":"","height":""}],"author":"WordPress Administrator","twitter_card":"summary_large_image","twitter_misc":{"Written by":"WordPress Administrator","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/"},"author":{"name":"WordPress Administrator","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"headline":"SQL on Windows Addendum pack","datePublished":"2020-04-15T12:40:59+00:00","dateModified":"2020-04-15T14:35:32+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/"},"wordCount":408,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2020\/04\/TuningCarburetor.jpg","keywords":["addendum","MP","mp author","mp authoring","MSSQL","MSSQL on Windows","SCOM","sql","SQL Agnostic","SQL monitoring","SQL on windows"],"articleSection":["Administration","Best Practice","MP Management Pack"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/","url":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/","name":"SQL on Windows Addendum pack - Kevin Justin's Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2020\/04\/TuningCarburetor.jpg","datePublished":"2020-04-15T12:40:59+00:00","dateModified":"2020-04-15T14:35:32+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2020\/04\/TuningCarburetor.jpg","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2020\/04\/TuningCarburetor.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2020\/04\/15\/sql-on-windows-addendum-pack\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL on Windows Addendum pack"}]},{"@type":"WebSite","@id":"https:\/\/kevinjustin.com\/blog\/#website","url":"https:\/\/kevinjustin.com\/blog\/","name":"Kevin Justin's Blog","description":"Operational monitoring tools including System Center, Azure Monitor","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kevinjustin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508","name":"WordPress Administrator","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","caption":"WordPress Administrator"},"sameAs":["https:\/\/kevinjustin.com"],"url":"https:\/\/kevinjustin.com\/blog\/author\/wordpress_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/6625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/comments?post=6625"}],"version-history":[{"count":17,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/6625\/revisions"}],"predecessor-version":[{"id":6643,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/6625\/revisions\/6643"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=6625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=6625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=6625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}