{"id":713,"date":"2014-09-25T14:07:00","date_gmt":"2014-09-25T21:07:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/"},"modified":"2024-01-22T22:48:48","modified_gmt":"2024-01-23T06:48:48","slug":"using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/","title":{"rendered":"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions"},"content":{"rendered":"<p>A common practice on-premise to improve the performance of SQL Server workloads is storing <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms190768.aspx?WT.mc_id=Blog_SQL_Announce_DI\">TempDB<\/a> and\/or <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn133176.aspx?WT.mc_id=Blog_SQL_Announce_DI\">Buffer Pool Extensions (SQL Server 2014)<\/a> on SSDs. The former improves the performance of workloads that use temporary objects heavily (e.g. queries handling large recordsets, index rebuilds, row versioning isolation levels, temp tables, and triggers). The latter improves the performance of read workloads which working set doesn\u2019t fit in memory.<\/p>\n<p>Now you can do the same in Azure VMs using the new D-Series VM Sizes.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_1.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\" original-url=\"http:\/\/blogs.technet.com\/resized-image.ashx\/__size\/550x0\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_1.png\" border=\"0\" alt=\" \" srcset=\"\"><\/a><\/p>\n<p><b>Important: The SSD drive is transient<\/b><\/p>\n<p>The SSD drive (D:\\) is not persistent, so its contents and permissions will be lost if the VM moves to a different host. This can happen in case of a host failure or a VM resize operation.<\/p>\n<ul>\n<li>Do not store your data or log files there. Use (persistent) drives from Azure Storage.<\/li>\n<li>If using TempDB and\/or Buffer Pool Extensions, SQL Server requires accessing the directory specified to store them. The following section describes how to store SQL Server TempDB and\/or Buffer Pool Extensions on the SSD drive and automatically recreate directory if the VM moves to a different host.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p><b><span style=\"text-decoration:underline;\">Configuration Steps<\/span><\/b><\/p>\n<p><b>1) Create a folder in the D:\\ drive<\/b><\/p>\n<p>This is the folder that you will store TempDB and\/or Buffer Pool Extensions in, for example as \u201cD:\\SQLTEMP\u201d.<\/p>\n<\/p>\n<p><b>2) To move TempDB to the SSD<\/b><\/p>\n<p>Using SSMS connect to your SQL Server instance. Execute the following T-SQL commands to change location of the TempDB files:<b><\/b><\/p>\n<p><i>USE MASTER<\/i><\/p>\n<p><i>GO<\/i><\/p>\n<p><i>ALTER DATABASE tempdb MODIFY FILE (NAME= tempdev, FILENAME= &#8216;D:\\SQLTEMP\\tempdb.mdf&#8217;) <br \/> GO<\/i><\/p>\n<p><i>ALTER DATABASE tempdb MODIFY FILE (name = templog, filename = &#8216;D:\\SQLTEMP\\templog.ldf&#8217;) <br \/> GO<\/i><\/p>\n<p><i>\u00a0<\/i><\/p>\n<p><b>2) To configure Buffer Pool Extensions in the SSD<\/b><\/p>\n<p>Using SSMS connect to your SQL Server instance. Execute the following T-SQL commands to configure the Buffer Pool Extension, specifying the location and size of its file. The general recommendation is to set the size to 4-6 times the size of the VM memory. For more details read the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn133176.aspx?WT.mc_id=Blog_SQL_Announce_DI\">documentation<\/a>.<\/p>\n<p><i>ALTER SERVER CONFIGURATION <\/i><\/p>\n<p><i>SET BUFFER POOL EXTENSION ON<\/i><\/p>\n<p><i>( FILENAME = &#8216;D:\\SQLTEMP\\ExtensionFile.BPE&#8217; , SIZE = &lt;size&gt; [ KB | MB | GB ] )<\/i><\/p>\n<p>\u00a0<\/p>\n<p><b>3) Configure the Start Mode of SQL Server and SQL Agent startup as Manual<\/b><\/p>\n<p>Using Configuration Manager set the Start Mode of SQL Server and SQL Agent as Manual.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-2.png\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_2.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-2.png\" original-url=\"http:\/\/blogs.technet.com\/resized-image.ashx\/__size\/550x0\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_2.png\" border=\"0\" alt=\" \" srcset=\"\"><\/a><\/p>\n<p>\u00a0<\/p>\n<p><b>4) Create a Powershell script to recreate the folder in D:\\ if needed and start SQL server<\/b><\/p>\n<p>Copy and paste the following script and save it as a Powershell file in the C:\\ drive (OS drive), for example as \u201cC:\\<i>SQL-startup.ps1\u201d. <\/i>If needed, modify the D:\\ folder to the one you specified in Step 1.<i><\/i><\/p>\n<p><i>$SQLService=&#8221;SQL Server (MSSQLSERVER)&#8221;<br \/> $SQLAgentService=&#8221;SQL Server Agent (MSSQLSERVER)&#8221;<br \/> $tempfolder=&#8221;D:\\SQLTEMP&#8221;<br \/> if (!(test-path -path $tempfolder)) {<br \/> \u00a0\u00a0\u00a0\u00a0New-Item -ItemType directory -Path $tempfolder<br \/> }<br \/> Start-Service $SQLService<br \/> Start-Service $SQLAgentService<\/i><\/p>\n<p><i>\u00a0<\/i><\/p>\n<p><b>5) Change the Powershell Execution Policy to allow the execution of signed scripts<\/b><\/p>\n<p>From the Powershell console execute <i>Set-ExecutionPolicy RemoteSigned<\/i><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-3.png\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_3.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-3.png\" original-url=\"http:\/\/blogs.technet.com\/resized-image.ashx\/__size\/550x0\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_3.png\" border=\"0\" alt=\" \" srcset=\"\"><\/a><\/p>\n<p><b>6)\u00a0\u00a0\u00a0\u00a0\u00a0 Create a schedule task at system startup to execute the Powershell script<\/b><\/p>\n<p>Using Task Scheduler create a Basic Task that executes when the computer starts and executes the script in the Powershell file. For this, specify:<\/p>\n<ul>\n<li>Program\/script: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <i>powershell <\/i>\n<\/li>\n<li>Arguments:<i> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2013file \u2018C:\\SQL-startup.ps1\u2019<\/i>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-4.png\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_4.png\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-4.png\" original-url=\"http:\/\/blogs.technet.com\/resized-image.ashx\/__size\/550x0\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54\/dpi_2D00_sep25_2D00_4.png\" border=\"0\" alt=\" \" srcset=\"\"><\/a><\/p>\n<p><b><br \/> 7) Test the setup <\/b><\/p>\n<p>Restart the VM and verify using Configuration Manager that the SQL Server service is started.<\/p>\n<p>This guarantees that if the VM moves to a different host SQL Server will start successfully.<\/p>\n<p>\u00a0<\/p>\n<p>Try the D-SERIES VM SIZES at the <a href=\"https:\/\/portal.azure.com\/?WT.mc_id=Blog_SQL_Announce_DI\">AZURE PORTAL<\/a> today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and\/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of workloads that use temporary objects heavily (e.g. queries handling large recordsets, index rebuilds, row versioning isolation levels, temp tables, and triggers).<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2424],"topic":[],"coauthors":[2487],"class_list":["post-713","post","type-post","status-publish","format-standard","hentry","content-type-best-practices"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server 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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and\/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of workloads that use temporary objects heavily (e.g. queries handling large recordsets, index rebuilds, row versioning isolation levels, temp tables, and triggers).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-25T21:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:48:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions\",\"datePublished\":\"2014-09-25T21:07:00+00:00\",\"dateModified\":\"2024-01-23T06:48:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\"},\"wordCount\":580,\"commentCount\":12,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\",\"name\":\"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\",\"datePublished\":\"2014-09-25T21:07:00+00:00\",\"dateModified\":\"2024-01-23T06:48:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server 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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/","og_locale":"en_US","og_type":"article","og_title":"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server Blog","og_description":"A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and\/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of workloads that use temporary objects heavily (e.g. queries handling large recordsets, index rebuilds, row versioning isolation levels, temp tables, and triggers).","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2014-09-25T21:07:00+00:00","article_modified_time":"2024-01-23T06:48:48+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions","datePublished":"2014-09-25T21:07:00+00:00","dateModified":"2024-01-23T06:48:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/"},"wordCount":580,"commentCount":12,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/","name":"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png","datePublished":"2014-09-25T21:07:00+00:00","dateModified":"2024-01-23T06:48:48+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/dpi-sep25-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/09\/25\/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=713"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/713\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=713"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=713"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=713"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=713"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=713"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}