{"id":9575,"date":"2009-04-01T09:54:00","date_gmt":"1999-11-29T20:00:00","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=9575"},"modified":"2009-04-01T09:54:00","modified_gmt":"1999-11-29T20:00:00","slug":"new-sql-server-mp-for-opsmgr-2007","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=9575","title":{"rendered":"New SQL Server MP for OpsMgr 2007"},"content":{"rendered":"<\/p>\n<p>Microsoft has <a title=\"released\" href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?displaylang=en&amp;FamilyID=8c0f970e-c653-4c15-9e51-6a6cadfca363#tm\">released<\/a> <em>another<\/em> new update to the SQL management pack for Operations Manager 2007.\u00a0 The download page says nothing about what is new or fixed.\u00a0 My advice is simple: steer clear for a while and watch the forums\/blogs.\u00a0 The last time I updated the SQL management pack I had a flood of false alarms due to bugs in the management pack.\u00a0 Once you\u2019re ready for it, deploy it in a lab and see if you get alerts for no reason.\u00a0 Then deploy it on live, ideally when things are quiet and with lots of notifications so people are aware there could be critical alerts that are cause by bugs.\n<\/p>\n<p>I\u2019m not alone when it comes to being critical of the SQL management pack.\u00a0 The quality control hasn\u2019t been great and it\u2019s very public.\n<\/p>\n<p>EDIT #1\n<\/p>\n<p>The OpsMgr bog <a href=\"http:\/\/blogs.technet.com\/momteam\/archive\/2009\/04\/01\/sql-server-mp-version-6-0-6569-0-is-now-released.aspx\">announced<\/a> the fixes in this management pack.\u00a0 These are:<\/p>\n<ul>\n<li><em>&quot;Fixed performance issues caused by excessive CPU utilization and script timeouts from Windows Management Instrumentation (WMI) queries in the following management pack discoveries: Discover SQL Server 2005 Database Engines (Windows Server), Discover SQL Server 2005 Reporting Services (Windows Server), Discover SQL Server 2005 Analysis Services (Windows Server), Discover SQL Server 2008 Database Engines (Windows Server), Discover SQL Server 2008 Reporting Services (Windows Server), Discover SQL Server 2008 Analysis Services (Windows Server).<\/em>\n<\/li>\n<li><em>Fixed an issue where SQL Server 2005 and SQL Server 2008 Analysis Services and Reporting Services discoveries were not reliably discovering these objects on instances of SQL Server that did not have the Database\u00a0 Engine installed.<\/em>\n<\/li>\n<li><em>Removed the hard-coded exception in rules and monitors that prevented the monitoring of the System, Temp, and Master databases.<\/em>\n<\/li>\n<li><em>Improved the means by which database discoveries recognize auto growth enabled settings. Database discoveries now recognize both \u201cKB\u201d and \u201c%\u201d growth settings; previously the database discoveries recognized only the \u201cKB\u201d growth setting&quot;.<br \/>Corrected typographical errors in product knowledge and improved the quality of the text.<br \/><\/em><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has released another new update to the SQL management pack for Operations Manager 2007.\u00a0 The download page says nothing about what is new or fixed.\u00a0 My advice is simple: steer clear for a while and watch the forums\/blogs.\u00a0 The last time I updated the SQL management pack I had a flood of false alarms &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=9575\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;New SQL Server MP for OpsMgr 2007&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[39],"tags":[],"class_list":["post-9575","post","type-post","status-publish","format-standard","hentry","category-sql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"AFinn\"\/>\n\t<meta name=\"google-site-verification\" content=\"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aidanfinn.com\/?p=9575\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro\" \/>\n\t\t<meta property=\"og:description\" content=\"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aidanfinn.com\/?p=9575\" \/>\n\t\t<meta property=\"article:published_time\" content=\"1999-11-29T20:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"1999-11-29T20:00:00+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@joe_elway\" \/>\n\t\t<meta name=\"twitter:title\" content=\"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@joe_elway\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#article\",\"name\":\"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro\",\"headline\":\"New SQL Server MP for OpsMgr 2007\",\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"},\"datePublished\":\"2009-04-01T09:54:00+01:00\",\"dateModified\":\"2009-04-01T09:54:00+01:00\",\"inLanguage\":\"en-GB\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#webpage\"},\"articleSection\":\"SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aidanfinn.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#listItem\",\"name\":\"New SQL Server MP for OpsMgr 2007\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#listItem\",\"position\":3,\"name\":\"New SQL Server MP for OpsMgr 2007\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#webpage\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575\",\"name\":\"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro\",\"description\":\"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\\\/blogs. The last time I updated the SQL management pack I had a flood of false alarms\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=9575#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"datePublished\":\"2009-04-01T09:54:00+01:00\",\"dateModified\":\"2009-04-01T09:54:00+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"name\":\"Aidan Finn, IT Pro\",\"description\":\"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro","description":"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms","canonical_url":"https:\/\/aidanfinn.com\/?p=9575","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aidanfinn.com\/?p=9575#article","name":"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro","headline":"New SQL Server MP for OpsMgr 2007","author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"publisher":{"@id":"https:\/\/aidanfinn.com\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=9575#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"},"datePublished":"2009-04-01T09:54:00+01:00","dateModified":"2009-04-01T09:54:00+01:00","inLanguage":"en-GB","mainEntityOfPage":{"@id":"https:\/\/aidanfinn.com\/?p=9575#webpage"},"isPartOf":{"@id":"https:\/\/aidanfinn.com\/?p=9575#webpage"},"articleSection":"SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/aidanfinn.com\/?p=9575#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aidanfinn.com#listItem","position":1,"name":"Home","item":"https:\/\/aidanfinn.com","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","position":2,"name":"SQL","item":"https:\/\/aidanfinn.com\/?cat=39","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=9575#listItem","name":"New SQL Server MP for OpsMgr 2007"},"previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=9575#listItem","position":3,"name":"New SQL Server MP for OpsMgr 2007","previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}}]},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/#person","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=9575#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/?author=1#author","url":"https:\/\/aidanfinn.com\/?author=1","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=9575#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"WebPage","@id":"https:\/\/aidanfinn.com\/?p=9575#webpage","url":"https:\/\/aidanfinn.com\/?p=9575","name":"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro","description":"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/aidanfinn.com\/#website"},"breadcrumb":{"@id":"https:\/\/aidanfinn.com\/?p=9575#breadcrumblist"},"author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"creator":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"datePublished":"2009-04-01T09:54:00+01:00","dateModified":"2009-04-01T09:54:00+01:00"},{"@type":"WebSite","@id":"https:\/\/aidanfinn.com\/#website","url":"https:\/\/aidanfinn.com\/","name":"Aidan Finn, IT Pro","description":"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","inLanguage":"en-GB","publisher":{"@id":"https:\/\/aidanfinn.com\/#person"}}]},"og:locale":"en_GB","og:site_name":"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","og:type":"article","og:title":"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro","og:description":"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms","og:url":"https:\/\/aidanfinn.com\/?p=9575","article:published_time":"1999-11-29T20:00:00+00:00","article:modified_time":"1999-11-29T20:00:00+00:00","twitter:card":"summary","twitter:site":"@joe_elway","twitter:title":"New SQL Server MP for OpsMgr 2007 | Aidan Finn, IT Pro","twitter:description":"Microsoft has released another new update to the SQL management pack for Operations Manager 2007. The download page says nothing about what is new or fixed. My advice is simple: steer clear for a while and watch the forums\/blogs. The last time I updated the SQL management pack I had a flood of false alarms","twitter:creator":"@joe_elway"},"aioseo_meta_data":{"post_id":"9575","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 03:53:14","updated":"2025-06-04 12:49:52","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/?cat=39\" title=\"SQL\">SQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tNew SQL Server MP for OpsMgr 2007\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/aidanfinn.com"},{"label":"SQL","link":"https:\/\/aidanfinn.com\/?cat=39"},{"label":"New SQL Server MP for OpsMgr 2007","link":"https:\/\/aidanfinn.com\/?p=9575"}],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9575"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9575\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}