{"id":4860,"date":"2015-06-12T07:42:22","date_gmt":"2015-06-12T05:42:22","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/"},"modified":"2015-06-12T07:42:22","modified_gmt":"2015-06-12T05:42:22","slug":"sql-server-2016-ctp2-first-thoughts-about-tempdb-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/","title":{"rendered":"SQL Server 2016 CTP2 : first thoughts about tempdb database"},"content":{"rendered":"<div><img decoding=\"async\" class=\"blog-image\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\" alt=\"\" \/><\/div>\n<p>In my first <a title=\"SQL server 2016 - ctp2\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-ctp2-is-out\/\">blog<\/a> about SQL Server 2016, I noticed during the SQL Server installation process that we are able to configure the number of files for tempdb. This is surely a great improvement but at this point, you may think that the configuration of the tempdb database is finished but in fact you\u2019re wrong.<\/p>\n<p>Let me say why. First let\u2019s have a look at the tempdb files configuration after installing SQL Server.<\/p>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">use tempdb;\ngo\n\u00a0\nselect\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 name,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 physical_name,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 size * 8 as siz_kb,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case is_percent_growth\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 when 0 then concat(growth * 8, 'KB')\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else concat(cast(growth as decimal(5, 2)), '%')\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 end growth\nfrom sys.database_files;\ngo<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_46-_1_-_tempdb_first_config.jpg\" alt=\"blog_46-_1_-_tempdb_first_config\" width=\"620\" height=\"100\" \/><\/p>\n<p>On my virtual environment, the installation process has detected 4 VCPUs and it will automatically assign 4 files for tempdb in my case. If we take a look at the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms190768(v=sql.130).aspx\">BOL<\/a>, we can see the maximum number of files that can be assigned by the installer is 8. At this point, we may think this is a very interesting improvement because I faced some performance issues caused by a misconfigured tempdb database during my career. However let\u2019s take a look at the default parameters set by the installer: first, all data files are configured with a size of 8MB as well as the growth value with 10%. Next, let\u2019s have a look at the default path \u2026 Ok, it seems that we still have extra steps to finalize the configuration of the tempdb database and for the moment, I\u2019m not sure we can push in the trash our post-install script for tempdb. Having some additional parameters from the installer (GUI and script) to configure tempdb may be a good idea, so I guess we should keep an eye on this configuration area for the next CTP release.<\/p>\n<p>But that\u2019s not all, we also have others good news in this topic: trace flags 1117 (grow all files in a filegroup equally) and 1118 (full extent only) are no longer needed for tempdb database. This is a good news because implementing the trace flag 1117 impacts all databases on the server.<\/p>\n<p>Let me show you with some tests:<\/p>\n<div>&#8212; perform a checkpoint to empty the Tlog<\/div>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">checkpoint;\ngo<\/pre>\n<\/div>\n<div><\/div>\n<div>&#8212; create a user in tempdb<\/div>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">create table #t_extent_uniform\n(\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 id int default 1,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 col1 varchar(50) default 'T'\n);\ngo<\/pre>\n<\/div>\n<div><\/div>\n<div>&#8212; insert one record to allocate pages<\/div>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">insert #t_extent_uniform default values;\ngo<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Next. Let\u2019s take a look at the transaction log content by using the undocumented function sys.fn_db_log(). (Note that there are several ways to check allocation. Using sys.fn_db_log() function is one of them).<\/p>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Current LSN],\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Operation,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Context,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AllocUnitName,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Description\nfrom sys.fn_dblog(null, null);\ngo<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_46-_2_-_extent_allocation_.jpg\" alt=\"blog_46-_2_-_extent_allocation_\" width=\"628\" height=\"87\" \/><\/p>\n<p>Ok, after inserting my record, I can confirm that SQL Server has allocated a uniform extent for my object.<\/p>\n<p>Let\u2019s continue by checking if SQL Server will grow uniformly the tempdb data files. First I recreated a temporary table with a sufficient row size to fill up quickly a data page.<\/p>\n<div>&#8212; create a user in tempdb<\/div>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">create table #t_extent_uniform\n(\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 id int default 1,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 col1 char(8000) default 'T'\n);\ngo<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p>We will check up the growing and filling of the tempdb data files by using the following script:<\/p>\n<div>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">use tempdb;\ngo\n\u00a0\nselect\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 name,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 physical_name,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 size \/ 128 as siz_mb,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case is_percent_growth\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 when 0 then concat(growth * 8, 'KB')\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else concat(cast(growth as decimal(5, 2)), '%')\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 end growth,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cast(FILEPROPERTY(name, 'SpaceUsed') * 100. \/ size as decimal(15, 2)) as space_used_percent\nfrom sys.database_files\nwhere type_desc = 'ROWS'\ngo<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p>So let\u2019s perform a basic test by inserting a bunch of data to raise a growth of the tempdb data files:<br \/>\n&#8211; Here the situation before inserting the data:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_46-_3_-_tempdb_data_size.jpg\" alt=\"blog_46-_3_-_tempdb_data_size\" width=\"602\" height=\"94\" \/><\/p>\n<p>&#8211; Before raising the growing of the tempdb data files:<br \/>\nAt this point, all the data files are filled up by SQL Server as expected:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_46-_4_-_tempdb_data_size.jpg\" alt=\"blog_46-_4_-_tempdb_data_size\" width=\"598\" height=\"99\" \/><\/p>\n<p>&#8211; And after several insertions and grow of the tempdb data files:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_46-_5_-_tempdb_data_size.jpg\" alt=\"blog_46-_5_-_tempdb_data_size\" width=\"600\" height=\"104\" \/><\/p>\n<p>We performed basic tests here and we will have probably to take into account other real scenarios but for the moment, let\u2019s savour these good news. But just to clarify, this improvement is not magic and we will still face some concurrency issues with workloads that use heavily the tempdb database. However,\u00a0 introducing this new configuration area directly from the installer may encourage DBAs to be aware of the tempdb database.\u00a0 Just note that it still remains some other interesting mechanisms in order to improve concurrency of tempdb as caching mechanism but it often requires reviewing the T-SQL code from the application side (In my opinion, this is probably the most important improvement that I have ever seen on the tempdb topic).<\/p>\n<p>I\u2019m confident that we\u2019ll get other good news, so stay connected!<\/p>\n<p>By David Barbarin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my first blog about SQL Server 2016, I noticed during the SQL Server installation process that we are able to configure the number of files for tempdb. This is surely a great improvement but at this point, you may think that the configuration of the tempdb database is finished but in fact you\u2019re wrong. [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":4856,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368],"tags":[67,566,430],"type_dbi":[],"class_list":["post-4860","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","tag-performance","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 CTP2 : first thoughts about tempdb database - dbi Blog<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 CTP2 : first thoughts about tempdb database\" \/>\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-ctp2-first-thoughts-about-tempdb-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 CTP2 : first thoughts about tempdb database\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 CTP2 : first thoughts about tempdb database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-12T05:42:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"520\" \/>\n\t<meta property=\"og:image:height\" content=\"245\" \/>\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=\"4 minutes\" \/>\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-ctp2-first-thoughts-about-tempdb-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server 2016 CTP2 : first thoughts about tempdb database\",\"datePublished\":\"2015-06-12T05:42:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\"},\"wordCount\":671,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"keywords\":[\"Performance\",\"SQL Server 2016\",\"tempdb\"],\"articleSection\":[\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\",\"name\":\"SQL Server 2016 CTP2 : first thoughts about tempdb database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"datePublished\":\"2015-06-12T05:42:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"SQL Server 2016 CTP2 : first thoughts about tempdb database\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"width\":520,\"height\":245},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 CTP2 : first thoughts about tempdb database\"}]},{\"@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 CTP2 : first thoughts about tempdb database - dbi Blog","description":"SQL Server 2016 CTP2 : first thoughts about tempdb database","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-ctp2-first-thoughts-about-tempdb-database\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 CTP2 : first thoughts about tempdb database","og_description":"SQL Server 2016 CTP2 : first thoughts about tempdb database","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/","og_site_name":"dbi Blog","article_published_time":"2015-06-12T05:42:22+00:00","og_image":[{"width":520,"height":245,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server 2016 CTP2 : first thoughts about tempdb database","datePublished":"2015-06-12T05:42:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/"},"wordCount":671,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","keywords":["Performance","SQL Server 2016","tempdb"],"articleSection":["Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/","name":"SQL Server 2016 CTP2 : first thoughts about tempdb database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","datePublished":"2015-06-12T05:42:22+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"SQL Server 2016 CTP2 : first thoughts about tempdb database","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","width":520,"height":245},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp2-first-thoughts-about-tempdb-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 CTP2 : first thoughts about tempdb database"}]},{"@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\/4860","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=4860"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4860\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4856"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4860"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}