{"id":4646,"date":"2015-05-18T10:44:21","date_gmt":"2015-05-18T08:44:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/"},"modified":"2015-05-18T10:44:21","modified_gmt":"2015-05-18T08:44:21","slug":"when-tempdb-database-may-cause-indirect-issues","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/","title":{"rendered":"When tempdb database may cause indirect issues"},"content":{"rendered":"<div><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg\" alt=\"\" \/><\/div>\n<p>A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can\u2019t use his own information I decided to reproduce the same issue in order to share with you some interesting information. So the next part of this blog post refers exclusively to my own test but it represents exactly the real issue encountered by my friend.<\/p>\n<p>Let\u2019s set the scene: in the SQL Server error log we found the following records related to our issue:<\/p>\n<p><em>2015-04-16 14:06:16.54 Server\u00a0\u00a0\u00a0\u00a0 New queries assigned to process on Node 0 have not been picked up by a worker thread in the last 300 seconds. Blocking or long-running queries can contribute to this condition, and may degrade client response time. Use the &#8220;max worker threads&#8221; configuration option to increase number of allowable threads, or optimize current running queries. SQL Process Utilization: 0%. System Idle: 94%.<\/em><br \/>\n<em>2015-04-16 14:11:16.74 Server\u00a0\u00a0\u00a0\u00a0 New queries assigned to process on Node 0 have not been picked up by a worker thread in the last 600 seconds. Blocking or long-running queries can contribute to this condition, and may degrade client response time. Use the &#8220;max worker threads&#8221; configuration option to increase number of allowable threads, or optimize current running queries. SQL Process Utilization: 0%. System Idle: 92%.<\/em><\/p>\n<p>In the same time, we found an event related to the generation of a SQL Server dump file triggered by the deadlock schedulers monitor as follows:<\/p>\n<div><em>2015-04-16 14:06:04.66 Server\u00a0\u00a0\u00a0\u00a0 **Dump thread &#8211; spid = 0, EC = 0x0000000000000000<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 ***Stack Dump being sent to C:\\Program Files\\Microsoft SQL Server\\MSSQL12.MSSQLSERVER\\MSSQL\\Log<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 * *******************************************************************************<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 *<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 * BEGIN STACK DUMP:<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 *\u00a0\u00a0 16\/04\/15 14:06:04 spid 6392<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 *<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 * Deadlocked Schedulers<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 *<\/em><\/div>\n<div><em>2015-04-16 14:06:04.83 Server\u00a0\u00a0\u00a0\u00a0 * *******************************************************************************<\/em><\/div>\n<div><em>2015-03-27 01:05:02.83 Server\u00a0\u00a0\u00a0\u00a0 * &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/em><\/div>\n<div><em>2015-03-27 01:05:02.83 Server\u00a0\u00a0\u00a0\u00a0 * Short Stack Dump<\/em><\/div>\n<p>I began my investigation by having a first look at the SQL Server error log file but I didn\u2019t find any relevant information. So, I decided to move on the analysis of the dump file.<\/p>\n<p>My first idea was to look at the runaway threads at the moment of the dump file generation (!runawaycommand). In fact, I suspected first a high-CPU workload because I didn\u2019t get other information from my friend. Here what I found:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_39_-_1_-_runaway.jpg\" alt=\"blog_39_-_1_-_runaway\" width=\"234\" height=\"219\" \/><\/p>\n<p>I began my investigation by having a first look at the SQL Server error log file but I didn\u2019t find any relevant information. So, I decided to move on the analysis of the dump file.<\/p>\n<p>My first idea was to look at the runaway threads at the moment of the dump file generation (!runawaycommand). In fact, I suspected first a high-CPU workload because I didn\u2019t get other information from my friend. Here what I found:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_39_-_2_-_nb_of_running_threads.jpg\" alt=\"blog_39_-_2_-_nb_of_running_threads\" width=\"473\" height=\"52\" \/><\/p>\n<p>557 threads in use at the moment of the generation of the dump file. According to the Microsoft documentation<a href=\"https:\/\/technet.microsoft.com\/fr-fr\/library\/ms187024(v=sql.105).aspx\">here<\/a> and the concerned SQL Server infrastructure (4 logical processors and max worker thread option = 0), the number of running threads are greater than maximum of configured SQL Server threads equal to 512 in this case.<\/p>\n<p><em>SQL Server detected 2 sockets with 2 cores per socket and 2 logical processors per socket, 4 total logical processors;<\/em><\/p>\n<p>We found a lot of thread patterns that seem blocked by a database lock.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_39_-_3_-_call_stacks.jpg\" alt=\"blog_39_-_3_-_call_stacks\" width=\"626\" height=\"249\" \/><\/p>\n<p>Note in this case that SQL Server has decided to switch off the \u201ctied\u201d thread but it is still waiting to be signaled that the database lock is available to continue \u2026<br \/>\nAnother piece of interesting call stack is the following:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_39_-_4_-_call_stacks_2.jpg\" alt=\"blog_39_-_4_-_call_stacks_2\" width=\"615\" height=\"339\" \/><\/p>\n<p>This above call stack seems to concern the SQL Server start-up process. Let\u2019s take a look at the functions likesqlmin!DBMgr::OpenUnstartedDatabase, sqlmin!DBMgr::StartupDB orsqlmin!IMEDUtil::SynchronzeWithResourceDB .We can also notice the use of the functionsqlmin!StartUp::WaitForTempdbReady that seems to be related to tempdb database readiness. After that, the concerned thread is also waiting on the database lock to be available and we don\u2019t see any functions that state tempdb is ready at the moment of the dump file generation.<\/p>\n<p>Well, to summarize we are facing a general locking issue inside SQL Server process that has consumed all of available threads and we may think that tempdb readiness has something to do with this our blocking issue.<\/p>\n<p>So now, let\u2019s go back to the SQL Server error log and let\u2019s have a deeper look at the SQL Server error log event. At this point, I remembered the famous Bob Ward\u2019s session at Summit 2011 about tempdb database in which he explained the importance of tempdb database during the SQL Server start-up process because even if SQL Server is ready for user connections. Indeed, they have to wait until tempdb has really started and it makes sense because we can wonder what\u2019s going on if tempdb database cannot start correctly. Do we allow user connections to perform their work? As a reminder, the unavailability of tempdb is considered as a SQL Server shutdown event.<\/p>\n<p>In my context we found effectively that the tempdb database was ready only 40 minutes after SQL Server was ready for user connections as follows:<\/p>\n<div><em>2015-04-16 13:52:38.43 spid5s\u00a0\u00a0\u00a0\u00a0 Starting up database &#8216;master&#8217;.<\/em><\/div>\n<div><em>\u2026<\/em><\/div>\n<div><em>2015-04-16 13:53:05.76 spid9s\u00a0\u00a0\u00a0\u00a0 Starting up database &#8216;model&#8217;.<\/em><\/div>\n<div><em>\u2026<\/em><\/div>\n<div><em>2015-04-16 13:53:25.02 spid9s\u00a0\u00a0\u00a0\u00a0 Clearing tempdb database.<\/em><\/div>\n<div><em>\u2026<\/em><\/div>\n<div><em>2015-04-16 13:51:48.13 spid13s\u00a0\u00a0\u00a0\u00a0 SQL Server is now ready for client connections. This is an informational message; no user action is required.<\/em><\/div>\n<div><em>\u2026<\/em><\/div>\n<div><em>2015-04-16 14:32:12.28 spid9s\u00a0\u00a0\u00a0\u00a0 Starting up database &#8216;tempdb&#8217;.<\/em><\/div>\n<div><em>\u2026<\/em><\/div>\n<div><em>2015-04-16 14:32:15.71 spid9s\u00a0\u00a0\u00a0\u00a0 Recovery completed for database tempdb (database ID 2) in 2 second(s)<\/em><\/div>\n<p>&nbsp;<\/p>\n<p>The $100 dollar question: Why tempdb started so slowly? Well, I didn\u2019t have all information but my friend told me that they had a storage maintenance at the time \u2026 maybe we may correlate these two events together but without any further investigation, it is not possible to respond correctly about it.<\/p>\n<p>Anyway it was very interesting to see how the tempdb database may trigger an escalade of issues in this case. There are probably a lot of ways to reproduce this issue.<\/p>\n<p>Finally let me finish my blog post by explaining my test scenario. In fact to simulate the same issue than my friend, I created first a very big user table inside the model database to considerably slow down the start-up of my tempdb database. Then I configured tempdb with big database files in size without instant file initialization (zeroing is mandatory in this case for all of database files). In the same time, I used ostress tool to simulate roughly 600 running threads. Finally I let the magic happens &#8230;<\/p>\n<p>I hope this blog will help you in your database administrator daily work.<\/p>\n<p>By David Barbarin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can\u2019t use his own information I decided to reproduce the same issue in order to share with you some interesting information. So the next [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":3556,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[564,51,430,565],"type_dbi":[],"class_list":["post-4646","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-debug","tag-sql-server","tag-tempdb","tag-worker-threads"],"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>When tempdb database may cause indirect issues - dbi Blog<\/title>\n<meta name=\"description\" content=\"When tempdb database may cause indirect issues\" \/>\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\/when-tempdb-database-may-cause-indirect-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"When tempdb database may cause indirect issues\" \/>\n<meta property=\"og:description\" content=\"When tempdb database may cause indirect issues\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-18T08:44:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"473\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\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=\"6 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\/when-tempdb-database-may-cause-indirect-issues\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"When tempdb database may cause indirect issues\",\"datePublished\":\"2015-05-18T08:44:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/\"},\"wordCount\":1112,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg\",\"keywords\":[\"debug\",\"SQL Server\",\"tempdb\",\"worker threads\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/\",\"name\":\"When tempdb database may cause indirect issues - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg\",\"datePublished\":\"2015-05-18T08:44:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"When tempdb database may cause indirect issues\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg\",\"width\":473,\"height\":164},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"When tempdb database may cause indirect issues\"}]},{\"@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":"When tempdb database may cause indirect issues - dbi Blog","description":"When tempdb database may cause indirect issues","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\/when-tempdb-database-may-cause-indirect-issues\/","og_locale":"en_US","og_type":"article","og_title":"When tempdb database may cause indirect issues","og_description":"When tempdb database may cause indirect issues","og_url":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/","og_site_name":"dbi Blog","article_published_time":"2015-05-18T08:44:21+00:00","og_image":[{"width":473,"height":164,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"When tempdb database may cause indirect issues","datePublished":"2015-05-18T08:44:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/"},"wordCount":1112,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg","keywords":["debug","SQL Server","tempdb","worker threads"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/","url":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/","name":"When tempdb database may cause indirect issues - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg","datePublished":"2015-05-18T08:44:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"When tempdb database may cause indirect issues","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQLServer_20140326-103734_1.jpg","width":473,"height":164},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/when-tempdb-database-may-cause-indirect-issues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"When tempdb database may cause indirect issues"}]},{"@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\/4646","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=4646"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4646\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3556"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4646"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}