{"id":3832,"date":"2017-10-28T11:23:15","date_gmt":"2017-10-28T10:23:15","guid":{"rendered":"http:\/\/andreas-wolter.com\/?page_id=3832"},"modified":"2025-02-14T01:50:15","modified_gmt":"2025-02-14T00:50:15","slug":"sql-server-health-configuration-check","status":"publish","type":"page","link":"https:\/\/andreas-wolter.com\/en\/database-consulting-services\/sql-server-health-configuration-check\/","title":{"rendered":"SQL Server Health Check"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-8qstco-b25e7390d01cbcce01bb80b6dffb9cac\">\n#top .av-special-heading.av-8qstco-b25e7390d01cbcce01bb80b6dffb9cac{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-8qstco-b25e7390d01cbcce01bb80b6dffb9cac .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-8qstco-b25e7390d01cbcce01bb80b6dffb9cac .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-8qstco-b25e7390d01cbcce01bb80b6dffb9cac av-special-heading-h1 blockquote modern-quote modern-centered  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h1 class='av-special-heading-tag'  itemprop=\"headline\"  >SQL Server Health <span class='special_amp'>&amp;<\/span> Configuration Check<\/h1><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-70lvi0-88132156ae7ab5cb4c8c331662213f48 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>A Health Check for SQL Server is a <u>documentation of the actual state<\/u> of a system. Also included are a couple of performance indicators that may serve as a <u>small baseline<\/u>.<a href=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/SQL_Server_Health_Check.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4214\" src=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/SQL_Server_Health_Check.png\" alt=\"\" width=\"150\" height=\"113\" \/><\/a><\/p>\n<p>A Health Check ensures that the SQL Server instances meet a minimum configuration standard and that no basic erroneous settings or suboptimal default settings are present.<\/p>\n<p>By contrast, the <strong>large-scale Health Check<\/strong> takes it a step further in that it adjusts the results as much as possible to your specific environment, with your participation (i.e. by completing a questionnaire), whereas the \u201c<strong>small-scale Health Check<\/strong>\u201d takes general standards as the basis.<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-64flyw-3925ed153c45c6c454a5a3e2efeaa971 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The result, in the form of a documentation, can also be used as a baseline for<\/p>\n<ul>\n<li>IT audits<\/li>\n<li>performance analysis measures that may orientate themselves along this baseline<\/li>\n<li>troubleshooting<\/li>\n<li>a new setup and disaster recovery.<\/li>\n<\/ul>\n<p>As a form of IT auditing, it helps<\/p>\n<ul>\n<li>anticipate potential problems<\/li>\n<li>implement best practices and iteratively develop one\u2019s own, which in turn may result in improved availability and performance<\/li>\n<li>standardize SQL Server configuration across all levels of the institution.<\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-3upfrc-c52361a70a049b7d4ad0e4d6f66c609b '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>More 25 years of experience with SQL Server systems have produced a Health Check that comprises up to <strong>over 60 points<\/strong> in the <strong>following areas<\/strong>:<\/p>\n<ul>\n<li>Hardware configuration<\/li>\n<li>Operation system setting<\/li>\n<li>Windows Failover Clustering (when in use)<\/li>\n<li>SQL Server setting<\/li>\n<li>SQL Server security (high level)<\/li>\n<li>Database settings<\/li>\n<li>Database maintenance<\/li>\n<li>SQL Server Agent jobs<\/li>\n<li>configuration &#038; evaluation error logs<\/li>\n<li>Status check High Availability and DR<\/li>\n<li>General recommendations according to Sarpedon Quality Lab\u00ae standards<\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-1waxh4-aec066dd3a828a9d555b84e6e0f7ecde '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p><strong>Learn more about the benefits and ask for your individual offer. <a href=\"https:\/\/andreas-wolter.com\/en\/contact\/\">Contact me here<\/a>. <\/strong><\/p>\n<\/div><\/section>","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":0,"parent":4020,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3832","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/3832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=3832"}],"version-history":[{"count":13,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/3832\/revisions"}],"predecessor-version":[{"id":6687,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/3832\/revisions\/6687"}],"up":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4020"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=3832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}