{"id":439,"date":"2018-11-30T09:35:13","date_gmt":"2018-11-30T09:35:13","guid":{"rendered":"http:\/\/www.cdesystems.co.uk\/?page_id=439"},"modified":"2018-11-30T09:35:13","modified_gmt":"2018-11-30T09:35:13","slug":"tuning","status":"publish","type":"page","link":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/?page_id=439","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 database fast and reliable using our 4 point plan:<\/p>\n<h2>1. Monitor Workload<\/h2>\n<ul>\n<li>Measure database speed and query use under normal operation.<\/li>\n<li>Identify memory, resource and CPU bottlenecks.\n<ul>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>2. T-SQL Queries<\/h2>\n<ul>\n<li>Analyse and streamline the most used and resource-intensive queries and views.<\/li>\n<\/ul>\n<h2>3. Indexes<\/h2>\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.\n<ul>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>4. Settings<\/h2>\n<ul>\n<li>Review configuration and settings.<\/li>\n<li>Sometimes fine tuning the configuration can get you a considerable performance increase.<\/li>\n<li style=\"list-style-type: none;\"><\/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 database 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 queries [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":430,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-439","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\/439","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=439"}],"version-history":[{"count":0,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/439\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=\/wp\/v2\/pages\/430"}],"wp:attachment":[{"href":"https:\/\/quirky-lalande.209-97-142-59.plesk.page\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}