{"id":235,"date":"2018-10-29T08:20:54","date_gmt":"2018-10-29T08:20:54","guid":{"rendered":"http:\/\/www.cdesystems.co.uk\/?page_id=235"},"modified":"2018-10-29T08:20:54","modified_gmt":"2018-10-29T08:20:54","slug":"tuning","status":"publish","type":"page","link":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/?page_id=235","title":{"rendered":"Performance Tuning"},"content":{"rendered":"<h2>Slow systems cause frustration for your clients, staff and costs you money.<\/h2>\n<p>We can make your SQL Server fast and reliable using our 4 point plan:<\/p>\n<h2>1. Monitor Workload<\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Measure database speed and query use under normal operation.<\/li>\n<li>Identify memory, resource and CPU bottlenecks.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>2. T-SQL Queries<\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Analyse and streamline the most used and resource-intensive queries and views.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>3. Indexes<\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Review and update indexes to make the database structures more efficient.<\/li>\n<li>Identify where indexed views would optimise speed for complex calculation and data processing.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>4. Settings<\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>SQL Server&#8217;s default settings can lead to bad performance.<\/li>\n<li>Sometimes fine tuning the configuration can get you 20-30% performance increases.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Slow systems cause frustration for your clients, staff and costs you money. We can make your SQL Server fast and reliable using our 4 point plan: 1. Monitor Workload Measure database speed and query use under normal operation. Identify memory, resource and CPU bottlenecks. 2. T-SQL Queries Analyse and streamline the most used and resource-intensive [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":11,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-235","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=235"}],"version-history":[{"count":0,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/235\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/11"}],"wp:attachment":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}