{"id":19783,"date":"2023-08-18T12:26:30","date_gmt":"2023-08-18T16:26:30","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=19783"},"modified":"2023-08-23T11:29:30","modified_gmt":"2023-08-23T15:29:30","slug":"mssql-addendum-pack","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/","title":{"rendered":"MSSQL Addendum pack"},"content":{"rendered":"

 <\/p>\n

\"Time<\/a>
Time to tune MSSQL alerts!<\/figcaption><\/figure>\n

The ‘MSSQL Addendum pack’ wouldn’t be possible without Brandon Pires<\/a> contributions.\u00a0 Brandon dealt with my many questions to better alert!\u00a0 If you need more background, check the ‘why addendum pack’ post<\/a>.<\/p>\n

<\/h4>\n

Quick Download(s)<\/h4>\n

2012+ https:\/\/github.com\/theKevinJustin\/MSSQLAddendum<\/a><\/h4>\n

<\/h2>\n

 <\/p>\n

Capabilities<\/h4>\n

The pack is based on the SQL engineering blog<\/a> and program team making multiple updates per year for SQL monitoring.\u00a0 The addendum creates two groups for dev\/test and notification\/subscription modeling.\u00a0 Second, the overrides, man there are a bunch! aid consumption of real issues.\u00a0 \u00a0Lastly, most environments should be SQL 2016+, as the 2012R2 EOL\/EOSL<\/a> is quickly approaching in October!<\/p>\n

\"MSSQL<\/a>
MSSQL groups defined in the Addendum pack<\/figcaption><\/figure>\n

MSSQL group discoveries require updates to be applicable to environment<\/p>\n

 <\/p>\n

Tailor addendum<\/h2>\n

First, the Addendum pack requires the MSSQL packs MUST be installed.\u00a0 The addendum is based on the MSSQL 2016+ version agnostic is currently supported, as the 2012,2012R2 products are near end of support.<\/p>\n

Find\/Replace the variables as needed:<\/p>\n

Example\u00a0 \u00a0 ##TESTSERVER##|##DEVSERVER##<\/p>\n

Save file<\/p>\n

 <\/p>\n

Overrides<\/h4>\n

Addendum pack contains discovery, monitor, and rule overrides to tune MSSQL to CSA (old PFE\/CE\/CSAe Microsoft Field engineer recommendations), to match the health model reducing critical ‘wake me up in the middle of the night’ alerts.<\/p>\n

\"Partial<\/a>
Partial snapshot of MSSQL overrides in the pack<\/figcaption><\/figure>\n

<\/h3>\n

Import<\/strong><\/h4>\n

Download pack, and save to your environment<\/p>\n

Import into SCOM<\/p>\n

Enjoy!<\/p>\n

 <\/p>\n

 <\/p>\n

MSSQL Addendum references<\/strong><\/h3>\n

MSSQL Engineering blog<\/a> and old post here<\/a><\/p>\n

SQL Releases TechCommunity here<\/a><\/p>\n

Engineering team latest management pack, TechCommunity release v7.2.0.0<\/a><\/p>\n

Import ‘gotcha’ importing new custom functionality blog<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

  The ‘MSSQL Addendum pack’ wouldn’t be possible without Brandon Pires contributions.\u00a0 Brandon dealt with my many questions to better alert!\u00a0 If you need more background, check the ‘why addendum pack’ post. Quick Download(s) 2012+ https:\/\/github.com\/theKevinJustin\/MSSQLAddendum   Capabilities The pack is based on the SQL engineering blog and program team making multiple updates per year … Continue reading “MSSQL 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,567,5,7,530,556],"tags":[25,223,243,511,342,410,414,508,458],"class_list":["post-19783","post","type-post","status-publish","format-standard","hentry","category-administration","category-authoring","category-best-practice","category-mp-management-pack","category-scom","category-sql","tag-addendum","tag-management-pack","tag-mp","tag-mssql","tag-scom","tag-sql","tag-sql-engineering","tag-sql-monitoring","tag-tuning"],"yoast_head":"\nMSSQL Addendum pack - Kevin Justin's Blog<\/title>\n<meta name=\"description\" content=\"Time to tune MSSQL alerts with the Addendum pack adding two groups, ~150 overrides to the health model reducing critical alerts\" \/>\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\/2023\/08\/18\/mssql-addendum-pack\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSSQL Addendum pack - Kevin Justin's Blog\" \/>\n<meta property=\"og:description\" content=\"Time to tune MSSQL alerts with the Addendum pack adding two groups, ~150 overrides to the health model reducing critical alerts\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-18T16:26:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-23T15:29:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/MSFT-SQL-logo.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\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/\"},\"author\":{\"name\":\"WordPress Administrator\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"headline\":\"MSSQL Addendum pack\",\"datePublished\":\"2023-08-18T16:26:30+00:00\",\"dateModified\":\"2023-08-23T15:29:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/\"},\"wordCount\":287,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/MSFT-SQL-logo.jpg\",\"keywords\":[\"addendum\",\"management pack\",\"MP\",\"MSSQL\",\"SCOM\",\"sql\",\"sql engineering\",\"SQL monitoring\",\"tuning\"],\"articleSection\":[\"Administration\",\"Authoring\",\"Best Practice\",\"MP Management Pack\",\"SCOM\",\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/\",\"name\":\"MSSQL Addendum pack - Kevin Justin's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/MSFT-SQL-logo.jpg\",\"datePublished\":\"2023-08-18T16:26:30+00:00\",\"dateModified\":\"2023-08-23T15:29:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"description\":\"Time to tune MSSQL alerts with the Addendum pack adding two groups, ~150 overrides to the health model reducing critical alerts\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/MSFT-SQL-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/MSFT-SQL-logo.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2023\\\/08\\\/18\\\/mssql-addendum-pack\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MSSQL 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":"MSSQL Addendum pack - Kevin Justin's Blog","description":"Time to tune MSSQL alerts with the Addendum pack adding two groups, ~150 overrides to the health model reducing critical alerts","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\/2023\/08\/18\/mssql-addendum-pack\/","og_locale":"en_US","og_type":"article","og_title":"MSSQL Addendum pack - Kevin Justin's Blog","og_description":"Time to tune MSSQL alerts with the Addendum pack adding two groups, ~150 overrides to the health model reducing critical alerts","og_url":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/","og_site_name":"Kevin Justin's Blog","article_published_time":"2023-08-18T16:26:30+00:00","article_modified_time":"2023-08-23T15:29:30+00:00","og_image":[{"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/MSFT-SQL-logo.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\/2023\/08\/18\/mssql-addendum-pack\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/"},"author":{"name":"WordPress Administrator","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"headline":"MSSQL Addendum pack","datePublished":"2023-08-18T16:26:30+00:00","dateModified":"2023-08-23T15:29:30+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/"},"wordCount":287,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/MSFT-SQL-logo.jpg","keywords":["addendum","management pack","MP","MSSQL","SCOM","sql","sql engineering","SQL monitoring","tuning"],"articleSection":["Administration","Authoring","Best Practice","MP Management Pack","SCOM","SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/","url":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/","name":"MSSQL Addendum pack - Kevin Justin's Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/MSFT-SQL-logo.jpg","datePublished":"2023-08-18T16:26:30+00:00","dateModified":"2023-08-23T15:29:30+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"description":"Time to tune MSSQL alerts with the Addendum pack adding two groups, ~150 overrides to the health model reducing critical alerts","breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/MSFT-SQL-logo.jpg","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2023\/08\/MSFT-SQL-logo.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2023\/08\/18\/mssql-addendum-pack\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MSSQL 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\/19783","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=19783"}],"version-history":[{"count":13,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/19783\/revisions"}],"predecessor-version":[{"id":19847,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/19783\/revisions\/19847"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=19783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=19783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=19783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}