{"id":14348,"date":"2019-12-24T06:19:15","date_gmt":"2019-12-24T06:19:15","guid":{"rendered":"https:\/\/dbtut.com\/?p=14348"},"modified":"2019-12-24T06:19:16","modified_gmt":"2019-12-24T06:19:16","slug":"automatic-tuning-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/","title":{"rendered":"Automatic Tuning in SQL Server"},"content":{"rendered":"<h2>What is Automatic Tuning in SQL Server?<\/h2>\n<p>Automatic Tuning is announced with SQL Server 2017.<\/p>\n<p>Automatic Tuning is a database feature that identifies potential performance problems, makes recommendations for solving these problems, or solves these problems automatically.<\/p>\n<p>Isn&#8217;t that exciting? You may be wondering whether SQL Server will perform all the performance operations by itself with this feature. Let me get to the point without you waiting any longer.<\/p>\n<h2>Automatic Tuning Types<\/h2>\n<p>There are two types of Automatic Tuning.<\/p>\n<ul>\n<li>Automatic Plan Correction<\/li>\n<li>Automatic Index Management<\/li>\n<\/ul>\n<h3>Automatic Plan Correction(Available for SQL Server 2017 and Azure SQL Database)<\/h3>\n<p>It solves performance plan-related performance problems by identifying problematic execution plans. In some cases, SQL Server creates a new execution plan for queries and query may run with worse performance than before. In such cases, if automatic plan correction is enabled, the latest execution plan, which is known to work well, is used instead of the newly created poor performance query plan. It can be enabled on the database as follows.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE database_name SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON );<\/pre>\n<p>You can manually set an execution plan with QueryStore. You can find detailed information about Query Store in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/15\/what-is-query-store-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Query Store in SQL Server<\/a>&#8220;.<\/p>\n<h3>Automatic Index Management(Available for Azure SQL Database)<\/h3>\n<p>It specifies the indexes that should be created and removed.<\/p>\n<p>It determines the index requirement needed in databases on Azure and automatically creates missing indexes and deletes unused indexes.<\/p>\n<p>You can enable automatic tuning on a database basis with the default settings of azure with the following query.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE database_name SET AUTOMATIC_TUNING = AUTO<\/pre>\n<p>If you want to set options on the current database manually you can use the below script.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE current SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON, CREATE_INDEX = DEFAULT, DROP_INDEX = OFF)<\/pre>\n<p>As most people thought, I thought that SQL Server may create unneeded indexes if we enable this feature. So normally when we look at the execution plan in the queries, we know that SQL Server recommends that we put 20 columns in the include column of the index as the missing index. Such situations often reduce rather than improve performance. Therefore, a good database administrator generally does not create every index recommended by SQL Server.<\/p>\n<p>Microsoft thought about that. After creating the index that it thinks its missing, it continues to monitor the system and deletes the index it created if necessary. Or, it continues to monitor the system after deleting the index that SQL Server thinks its not being used and if the performance is badly affected, it recreate the index.<\/p>\n<p>For more information about Indexes, I recommend you to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/12\/index-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Concept and Performance Effect On SQL Server<\/a>&#8220;.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14348\" class=\"pvc_stats all  \" data-element-id=\"14348\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is Automatic Tuning in SQL Server? Automatic Tuning is announced with SQL Server 2017. Automatic Tuning is a database feature that identifies potential performance problems, makes recommendations for solving these problems, or solves these problems automatically. Isn&#8217;t that exciting? You may be wondering whether SQL Server will perform all the performance operations by itself &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14348\" class=\"pvc_stats all  \" data-element-id=\"14348\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14352,"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":[3],"tags":[6927,6928,6932,6931,6933,6930,6929,6919,6923,6921,6922,6926,6920,6925,6939,6938,6934,6935,6937,6936,6924],"class_list":["post-14348","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-auto-tuning-in-sql-server","tag-auto-tuning-in-sql-server-2017","tag-auto-tuning-sql","tag-auto-tuning-sql-2017","tag-auto-tuning-sql-server","tag-automatic-database-tuning-in-sql-server","tag-automatic-database-tuning-in-sql-server-2017","tag-automatic-index-management","tag-automatic-plan-correction","tag-automatic-tuning","tag-automatic-tuning-in-sql-server","tag-automatic-tuning-in-sql-server-2017","tag-automatic-tuning-types","tag-how-automatic-tuning-works-in-sql-server","tag-sql-server-2017-automatic-query-tuning","tag-sql-server-2017-automatic-tuning","tag-sql-server-auto-tuning","tag-sql-server-automatic-tuning","tag-understanding-automatic-tuning-in-sql-server","tag-understanding-automatic-tuning-in-sql-server-2017","tag-what-is-automatic-tuning-in-sql-server"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":1023,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Automatic Tuning in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Automatic Tuning in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatic Tuning in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Automatic Tuning in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-24T06:19:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-24T06:19:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png\" \/>\n\t<meta property=\"og:image:width\" content=\"526\" \/>\n\t<meta property=\"og:image:height\" content=\"313\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Automatic Tuning in SQL Server\",\"datePublished\":\"2019-12-24T06:19:15+00:00\",\"dateModified\":\"2019-12-24T06:19:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\"},\"wordCount\":425,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png\",\"keywords\":[\"auto tuning in sql server\",\"auto tuning in sql server 2017\",\"auto tuning sql\",\"auto tuning sql 2017\",\"auto tuning sql server\",\"automatic database tuning in sql server\",\"automatic database tuning in sql server 2017\",\"Automatic Index Management\",\"Automatic Plan Correction\",\"Automatic Tuning\",\"Automatic Tuning in SQL Server\",\"automatic tuning in SQL Server 2017\",\"Automatic Tuning Types\",\"How Automatic Tuning Works in SQL Server\",\"SQL Server 2017 Automatic Query Tuning\",\"SQL Server 2017 Automatic Tuning\",\"sql server auto tuning\",\"sql server automatic tuning\",\"Understanding automatic tuning in SQL Server\",\"Understanding automatic tuning in SQL Server 2017\",\"What is Automatic Tuning in SQL Server\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\",\"name\":\"Automatic Tuning in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png\",\"datePublished\":\"2019-12-24T06:19:15+00:00\",\"dateModified\":\"2019-12-24T06:19:16+00:00\",\"description\":\"Automatic Tuning in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png\",\"width\":526,\"height\":313},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automatic Tuning in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automatic Tuning in SQL Server - Database Tutorials","description":"Automatic Tuning in SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Automatic Tuning in SQL Server - Database Tutorials","og_description":"Automatic Tuning in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-24T06:19:15+00:00","article_modified_time":"2019-12-24T06:19:16+00:00","og_image":[{"width":526,"height":313,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Automatic Tuning in SQL Server","datePublished":"2019-12-24T06:19:15+00:00","dateModified":"2019-12-24T06:19:16+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/"},"wordCount":425,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png","keywords":["auto tuning in sql server","auto tuning in sql server 2017","auto tuning sql","auto tuning sql 2017","auto tuning sql server","automatic database tuning in sql server","automatic database tuning in sql server 2017","Automatic Index Management","Automatic Plan Correction","Automatic Tuning","Automatic Tuning in SQL Server","automatic tuning in SQL Server 2017","Automatic Tuning Types","How Automatic Tuning Works in SQL Server","SQL Server 2017 Automatic Query Tuning","SQL Server 2017 Automatic Tuning","sql server auto tuning","sql server automatic tuning","Understanding automatic tuning in SQL Server","Understanding automatic tuning in SQL Server 2017","What is Automatic Tuning in SQL Server"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/","name":"Automatic Tuning in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png","datePublished":"2019-12-24T06:19:15+00:00","dateModified":"2019-12-24T06:19:16+00:00","description":"Automatic Tuning in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-17.png","width":526,"height":313},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/24\/automatic-tuning-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Automatic Tuning in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14348"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14348\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14352"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}