{"id":4103,"date":"2014-08-26T14:30:26","date_gmt":"2014-08-26T13:30:26","guid":{"rendered":"http:\/\/andreas-wolter.com\/database-consulting-services\/performance-analyse-sql-server\/"},"modified":"2025-02-14T01:54:37","modified_gmt":"2025-02-14T00:54:37","slug":"performance-analysis-sql-server","status":"publish","type":"page","link":"https:\/\/andreas-wolter.com\/en\/database-consulting-services\/performance-analysis-sql-server\/","title":{"rendered":"Performance Analysis"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-ut72lj-1931d83a158db33831ed0dd01a68e4fa\">\n#top .av-special-heading.av-ut72lj-1931d83a158db33831ed0dd01a68e4fa{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-ut72lj-1931d83a158db33831ed0dd01a68e4fa .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-ut72lj-1931d83a158db33831ed0dd01a68e4fa .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-ut72lj-1931d83a158db33831ed0dd01a68e4fa av-special-heading-h1 blockquote modern-quote modern-centered  avia-builder-el-0  el_before_av_hr  avia-builder-el-first '><h1 class='av-special-heading-tag'  itemprop=\"headline\"  >Performance Analysis SQL Server<\/h1><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-stgjx3-27694839cbd6f4594201f0e15ab581b2\">\n#top .hr.hr-invisible.av-stgjx3-27694839cbd6f4594201f0e15ab581b2{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-stgjx3-27694839cbd6f4594201f0e15ab581b2 hr-invisible  avia-builder-el-1  el_after_av_heading  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<section  class='av_textblock_section av-rtwjo7-335ab6ddb88ffb7f86a8ca490c6b0257 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><ul>\n<li>Your system exhibits unreasonable response times during business-critical times?<\/li>\n<li>You have repeatedly added new hardware without yielding significant changes?\n<ul>\n<li>Did you know that faster hard disks can yield a performance gain of up to 10%?<\/li>\n<li>Did you know that smartly created indexes can yield <u>several<\/u> 100% faster query results?<\/li>\n<\/ul>\n<\/li>\n<li>Your processor has an average load of 50%, but users are complaining because your forms are slow in reloading?<\/li>\n<li>The preparation of cubes takes hours even though the relation of the new data is low?<\/li>\n<li>How do I know if my system became slower, unless by angry calls from users?<\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-q6172v-52395fcc3059f2747234ca5c8a022193 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>These are only a few examples.<br \/>\nPerhaps one of these\u00a0problems sounds familiar to you, or perhaps you have quite a different issue.<\/p>\n<p>If you are unsure about where the causes lie, I will be happy to conduct an analysis of your system or create a baseline for a comparison.<\/p>\n<p>I have developed a comprehensive, standardized analysis of your database server that takes into account your complete system rather than only a component.<br \/>\nIn so doing, I analyze, among others:<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-2h9e6f-552791ce2e44dc556d327ab26cf5cd28\">\n.flex_column.av-2h9e6f-552791ce2e44dc556d327ab26cf5cd28{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-2h9e6f-552791ce2e44dc556d327ab26cf5cd28 av_one_full  avia-builder-el-4  el_after_av_textblock  el_before_av_hr  first flex_column_div av-zero-column-padding  column-top-margin'     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m3qzqv-d205c1983035b0df74093d2a298a8bd1\">\n#top .av-special-heading.av-m3qzqv-d205c1983035b0df74093d2a298a8bd1{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-m3qzqv-d205c1983035b0df74093d2a298a8bd1 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-m3qzqv-d205c1983035b0df74093d2a298a8bd1 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-m3qzqv-d205c1983035b0df74093d2a298a8bd1 av-special-heading-h4 blockquote modern-quote  avia-builder-el-5  el_before_av_textblock  avia-builder-el-first '><h4 class='av-special-heading-tag'  itemprop=\"headline\"  >The existing Resources<\/h4><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kygkxz-825a4e6344a65988bc1e71a3cc622731 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>They include <strong>CPU<\/strong>, <strong>memory, hard disks<\/strong> and their configuration. Frequently, up to 30% performance are wasted already here! Also, virtualization will be analyzed in the same run. The good news is: these areas are relatively easy to solve. The bad news is: most of the times, this area does not have the biggest potentials for improvements.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-j2ildz-0777ddd67253d67324c9374fc6711389\">\n#top .av-special-heading.av-j2ildz-0777ddd67253d67324c9374fc6711389{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-j2ildz-0777ddd67253d67324c9374fc6711389 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-j2ildz-0777ddd67253d67324c9374fc6711389 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-j2ildz-0777ddd67253d67324c9374fc6711389 av-special-heading-h4 blockquote modern-quote  avia-builder-el-7  el_after_av_textblock  el_before_av_textblock '><h4 class='av-special-heading-tag'  itemprop=\"headline\"  >The Configuration<\/h4><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-hl9dbr-42c9bd5bf1e2dec4787ba7a9b2d89540 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The configuration starts with the Windows Server operating system. Followed, of course, by the SQL Server itself.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-f6qvev-8562fa26e066a3a628923525f8d7a924\">\n#top .av-special-heading.av-f6qvev-8562fa26e066a3a628923525f8d7a924{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-f6qvev-8562fa26e066a3a628923525f8d7a924 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-f6qvev-8562fa26e066a3a628923525f8d7a924 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-f6qvev-8562fa26e066a3a628923525f8d7a924 av-special-heading-h4 blockquote modern-quote  avia-builder-el-9  el_after_av_textblock  el_before_av_textblock '><h4 class='av-special-heading-tag'  itemprop=\"headline\"  >The Databases<\/h4><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-dxti3r-3300421523d999bf8568da9c53ca0d04 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Certain\u00a0 database settings\u00a0may have dramatic performance effects or result in unnecessary risks for data loss. These will always be checked. The corresponding <strong>tables and indexes<\/strong> are in the databases. Here, apart from the queries themselves,\u00a0lies the greatest potential for performance improvements is. Therefore, the use of indexes is checked just as are\u00a0samples of a couple of striking <strong>queries<\/strong>.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-173nnb-7e4fc7b443136ef8e42c289928150785\">\n#top .av-special-heading.av-173nnb-7e4fc7b443136ef8e42c289928150785{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-173nnb-7e4fc7b443136ef8e42c289928150785 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-173nnb-7e4fc7b443136ef8e42c289928150785 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-173nnb-7e4fc7b443136ef8e42c289928150785 av-special-heading-h4 blockquote modern-quote  avia-builder-el-11  el_after_av_textblock  el_before_av_textblock '><h4 class='av-special-heading-tag'  itemprop=\"headline\"  >Transactions <span class='special_amp'>&amp;<\/span> Locks<\/h4><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-ax21bb-cd2c1647bc9ec2335ce1cb98525c1f38 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Certain systems such as ERP and CRM systems very often suffer from <strong>locks<\/strong>, which I generally treat and check as a core resource of the SQL Server.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-8ntv93-8279eef5e582a1f96ee28daa015a53e7\">\n#top .av-special-heading.av-8ntv93-8279eef5e582a1f96ee28daa015a53e7{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-8ntv93-8279eef5e582a1f96ee28daa015a53e7 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-8ntv93-8279eef5e582a1f96ee28daa015a53e7 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-8ntv93-8279eef5e582a1f96ee28daa015a53e7 av-special-heading-h4 blockquote modern-quote  avia-builder-el-13  el_after_av_textblock  el_before_av_textblock '><h4 class='av-special-heading-tag'  itemprop=\"headline\"  >The Technique:<\/h4><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-7ya5on-54eea30ebde96f9a03e1304429c135f2 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>We utilize Windows <strong>Performance Monitor<\/strong>, internal management views of SQL Server (<strong>DMVs<\/strong>), and for tracing, exclusively <strong>Extended Events<\/strong>. &#8211; We do not use SQL Server Profiler unless the system is older than SQL Server 2012.<\/p>\n<p>With this we can ensure and control the lowest monitoring overhead and limit further performance reduction.<\/p>\n<\/div><\/section><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-5c23hj-6c7c06a0f815b79f35fb25db378c1750\">\n#top .hr.hr-invisible.av-5c23hj-6c7c06a0f815b79f35fb25db378c1750{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-5c23hj-6c7c06a0f815b79f35fb25db378c1750 hr-invisible  avia-builder-el-15  el_after_av_one_full  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<section  class='av_textblock_section av-497rzb-78c7c6e1957d6c74ea707c60c14a7763 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>You will receive as a result a comprehensive documentation of your database system, as well as valuable advice as to with which changes you can exploit your resources even better, or where new hardware is indeed appropriate. In case the required techniques cannot be carried out by your own team, I am of course happy to support you in this regard. This analysis is also very useful, if not indispensable, as a documentation before or after a migration or consolidation.<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-2hie93-1450c3050ac48181d28c9453fa4ab3eb '   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":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-4103","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4103","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=4103"}],"version-history":[{"count":11,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4103\/revisions"}],"predecessor-version":[{"id":6689,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4103\/revisions\/6689"}],"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=4103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}