{"id":5748,"date":"2015-10-03T11:37:54","date_gmt":"2015-10-03T09:37:54","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/"},"modified":"2015-10-03T11:37:54","modified_gmt":"2015-10-03T09:37:54","slug":"sql-server-2016-tempdb-database-enhancements-in-ctp-2-4","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/","title":{"rendered":"SQL Server 2016 : tempdb database enhancements in CTP 2.4"},"content":{"rendered":"<p>The new CTP 2.4 has been released and announced by Microsoft in its blog <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">pos<\/a>t a couple of days ago. During my investigation, I noticed some new\u00a0 installer capabilities about the tempdb database. As a reminder, you can read my first thoughts from my blog post <a href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>, but to be short, the installer was able to provide automatically the right number of data files according to the number of existing CPUs and the best practices as well. But to be honest, it fell short of my own expectations because I was not able to configure other important parameters as autogrowth, filesize and file placements.<\/p>\n<p>With this CTP 2.4,\u00a0 that is fixed and we get more granular configuration in this topic as shown below:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4159\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4.jpg\" alt=\"blog 65- 1 - tempdb news 2.4\" width=\"300\" height=\"210\" \/><\/a><\/p>\n<p>Of course, you may also find out the corresponding parameters for unattended installation here:<\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\">SQLTEMPDBFILECOUNT=\"4\"\nSQLTEMPDBFILESIZE=\"8\"\nSQLTEMPDBFILEGROWTH=\"64\"\nSQLTEMPDBLOGFILESIZE=\"8\"\nSQLTEMPDBLOGFILEGROWTH=\"64\"\n<\/pre>\n<p>&nbsp;<\/p>\n<p>See you.<\/p>\n<p>By David Barbarin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The new CTP 2.4 has been released and announced by Microsoft in its blog post a couple of days ago. During my investigation, I noticed some new\u00a0 installer capabilities about the tempdb database. As a reminder, you can read my first thoughts from my blog post here, but to be short, the installer was able [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":5750,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[566,430],"type_dbi":[],"class_list":["post-5748","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-sql-server-2016","tag-tempdb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016 : tempdb database enhancements in CTP 2.4<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-03T09:37:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"588\" \/>\n\t<meta property=\"og:image:height\" content=\"411\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\",\"datePublished\":\"2015-10-03T09:37:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\"},\"wordCount\":148,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg\",\"keywords\":[\"SQL Server 2016\",\"tempdb\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\",\"name\":\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg\",\"datePublished\":\"2015-10-03T09:37:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg\",\"width\":588,\"height\":411},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 : tempdb database enhancements in CTP 2.4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","description":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","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:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","og_description":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/","og_site_name":"dbi Blog","article_published_time":"2015-10-03T09:37:54+00:00","og_image":[{"width":588,"height":411,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","datePublished":"2015-10-03T09:37:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/"},"wordCount":148,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg","keywords":["SQL Server 2016","tempdb"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/","name":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg","datePublished":"2015-10-03T09:37:54+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"SQL Server 2016 : tempdb database enhancements in CTP 2.4","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-65-1-tempdb-news-2.4-1.jpg","width":588,"height":411},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-tempdb-database-enhancements-in-ctp-2-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 : tempdb database enhancements in CTP 2.4"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5748"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5748\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5750"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5748"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}