{"id":105,"date":"2017-01-24T13:10:57","date_gmt":"2017-01-24T19:10:57","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=105"},"modified":"2019-12-20T10:30:13","modified_gmt":"2019-12-20T14:30:13","slug":"temp-db-recommendations-for-scom-201x","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/","title":{"rendered":"Temp DB recommendations for SCOM 201x"},"content":{"rendered":"<p>When someone asks you about TempDB sizing, does your jaw hit the floor?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"273\" height=\"160\" class=\"alignnone size-full wp-image-385\" alt=\"surprisesign\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif\" \/><\/p>\n<p>Time to pull out my handy detective skills<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"212\" height=\"151\" class=\"alignnone size-full wp-image-375\" alt=\"detectivehat\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/DetectiveHat.jpg\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Context &amp; Best Practices\u00a0<\/strong><br \/>\nSQL Server uses the tempdb database to store temporary objects. This can include temporary tables, stored procedures, work tables, and row versions. In short, most changes to user databases are routed through the tempdb database. Increasing the number of tempdb data files enables SQL Server to perform more concurrent operations, by distributing activity over multiple physical files.<\/p>\n<p><strong>Tip<\/strong> Modify properties of tempdb data files to have identical initial size and growth increment.<\/p>\n<p>&nbsp;<\/p>\n<p>Support <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/328551\/concurrency-enhancements-for-the-tempdb-database\">article<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"195\" class=\"alignnone size-full wp-image-115\" alt=\"sqlconcurrencytempdb\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/SQLConcurrencyTempDB.PNG\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>The Risk Assessment tool\u00a0(RAS) states<\/strong><\/p>\n<p>Increase the number of tempdb files in line with best practice guidance. As a general guideline, in an environment where tempdb is used heavily, the number of tempdb data files should be between 0.25 to 1.0 times the number of physical processor cores. On servers with more than eight physical cores, start with eight data files, and then increase or decrease the number of data files as needed.<\/p>\n<p>Example &#8211; 4 core SQL server needs at least 1 TempDB file<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Supporting resources<\/strong><br \/>\n2016 TempDB Database information\u00a0<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms190768.aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/ms190768.aspx<\/a><br \/>\nTempDB sizing <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms345368.aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/ms345368.aspx<\/a><br \/>\nOptimizing TempDB Performance <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms175527.aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/ms175527.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When someone asks you about TempDB sizing, does your jaw hit the floor? Time to pull out my handy detective skills &nbsp; Context &amp; Best Practices\u00a0 SQL Server uses the tempdb database to store temporary objects. This can include temporary tables, stored procedures, work tables, and row versions. In short, most changes to user databases &hellip; <a href=\"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Temp DB recommendations for SCOM 201x&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-105","post","type-post","status-publish","format-standard","hentry","category-best-practice"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Temp DB recommendations for SCOM 201x - Kevin Justin&#039;s Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Temp DB recommendations for SCOM 201x - Kevin Justin&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"When someone asks you about TempDB sizing, does your jaw hit the floor? Time to pull out my handy detective skills &nbsp; Context &amp; Best Practices\u00a0 SQL Server uses the tempdb database to store temporary objects. This can include temporary tables, stored procedures, work tables, and row versions. In short, most changes to user databases &hellip; Continue reading &quot;Temp DB recommendations for SCOM 201x&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-24T19:10:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-20T14:30:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif\" \/>\n<meta name=\"author\" content=\"Kevin Justin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kevin Justin\" \/>\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:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/\"},\"author\":{\"name\":\"Kevin Justin\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\"},\"headline\":\"Temp DB recommendations for SCOM 201x\",\"datePublished\":\"2017-01-24T19:10:57+00:00\",\"dateModified\":\"2019-12-20T14:30:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/\"},\"wordCount\":225,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/surpriseSign.gif\",\"articleSection\":[\"Best Practice\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/\",\"name\":\"Temp DB recommendations for SCOM 201x - Kevin Justin&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/surpriseSign.gif\",\"datePublished\":\"2017-01-24T19:10:57+00:00\",\"dateModified\":\"2019-12-20T14:30:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/surpriseSign.gif\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/surpriseSign.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/01\\\/24\\\/temp-db-recommendations-for-scom-201x\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Temp DB recommendations for SCOM 201x\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\",\"name\":\"Kevin Justin&#039;s Blog\",\"description\":\"Operational monitoring tools including System Center, Azure Monitor\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\",\"name\":\"Kevin Justin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"caption\":\"Kevin Justin\"},\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/author\\\/kejustin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Temp DB recommendations for SCOM 201x - Kevin Justin&#039;s Blog","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:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/","og_locale":"en_US","og_type":"article","og_title":"Temp DB recommendations for SCOM 201x - Kevin Justin&#039;s Blog","og_description":"When someone asks you about TempDB sizing, does your jaw hit the floor? Time to pull out my handy detective skills &nbsp; Context &amp; Best Practices\u00a0 SQL Server uses the tempdb database to store temporary objects. This can include temporary tables, stored procedures, work tables, and row versions. In short, most changes to user databases &hellip; Continue reading \"Temp DB recommendations for SCOM 201x\"","og_url":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/","og_site_name":"Kevin Justin&#039;s Blog","article_published_time":"2017-01-24T19:10:57+00:00","article_modified_time":"2019-12-20T14:30:13+00:00","og_image":[{"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif","type":"","width":"","height":""}],"author":"Kevin Justin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kevin Justin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/"},"author":{"name":"Kevin Justin","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d"},"headline":"Temp DB recommendations for SCOM 201x","datePublished":"2017-01-24T19:10:57+00:00","dateModified":"2019-12-20T14:30:13+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/"},"wordCount":225,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif","articleSection":["Best Practice"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/","url":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/","name":"Temp DB recommendations for SCOM 201x - Kevin Justin&#039;s Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif","datePublished":"2017-01-24T19:10:57+00:00","dateModified":"2019-12-20T14:30:13+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d"},"breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/01\/surpriseSign.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2017\/01\/24\/temp-db-recommendations-for-scom-201x\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Temp DB recommendations for SCOM 201x"}]},{"@type":"WebSite","@id":"https:\/\/kevinjustin.com\/blog\/#website","url":"https:\/\/kevinjustin.com\/blog\/","name":"Kevin Justin&#039;s Blog","description":"Operational monitoring tools including System Center, Azure Monitor","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kevinjustin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d","name":"Kevin Justin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","caption":"Kevin Justin"},"url":"https:\/\/kevinjustin.com\/blog\/author\/kejustin\/"}]}},"_links":{"self":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/comments?post=105"}],"version-history":[{"count":2,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/105\/revisions"}],"predecessor-version":[{"id":6537,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/105\/revisions\/6537"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}