{"id":753,"date":"2014-09-12T09:00:00","date_gmt":"2014-09-12T16:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/"},"modified":"2024-01-22T22:48:48","modified_gmt":"2024-01-23T06:48:48","slug":"new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/","title":{"rendered":"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery"},"content":{"rendered":"<p>We are delighted to announce the release of new optimized SQL Server images in the Microsoft Azure Virtual Machines Gallery. These images are pre-configured with optimizations for transactional and Data Warehousing workloads respectively by baking in <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/azure\/dn133149.aspx?WT.mc_id=Blog_SQL_Announce_Announce\">our performance best practices<\/a> for running SQL in Azure VMs.<\/p>\n<h2>What preconfigured VM images are available?<\/h2>\n<p>The following four new pre-configured VM images are now available in the Azure VM Gallery:<\/p>\n<ul>\n<li>SQL Server 2014 Enterprise Optimized for Transactional Workloads on Windows Server 2012 R2<\/li>\n<li>SQL Server 2014 Enterprise Optimized for Data Warehousing on Windows Server 2012 R2<\/li>\n<li>SQL Server 2012 SP2 Enterprise Optimized for Transactional Workloads on Windows Server 2012<\/li>\n<li>SQL Server 2012 SP2 Enterprise Optimized for Data Warehousing on Windows Server 2012<\/li>\n<\/ul>\n<p>Currently we support these images on VM instances that allow up to 16 data disks attached to provide the highest throughput (or aggregate bandwidth). Specifically, these instances are Standard Tier A4, A7, A8 and A9 and Basic tier A4. Please refer to <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/azure\/dn197896.aspx?WT.mc_id=Blog_SQL_Announce_Announce\">Virtual Machine and Cloud Service Sizes for Azure<\/a> for further details on the sizes and options.<\/p>\n<h2>How to provision a VM from the gallery using the new transactional\/DW images?<\/h2>\n<p>To provision an optimized transactional or DW VM image by using the Azure Management Portal,<\/p>\n<ol>\n<li>Sign in to the Azure Management Portal.<\/li>\n<li>Click VIRTUAL MACHINE in the Azure menu items in the left pane.<\/li>\n<li>Click NEW in the bottom left corner, and then choose COMPUTE, VIRTUAL MACHINE, and FROM GALLERY.<\/li>\n<li>On the Virtual machine image selection page, select one of the SQL Server for transactional or Data Warehousing images.<br \/>\n<a href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png\"><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png\" alt=\" \" border=\"0\" \/><\/a><\/li>\n<li>On the Virtual machine configuration page, in the SIZE option, choose from the supported sizes.<br \/>\n<a href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0246.dpi-sep12-2.png\"><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0246.dpi-sep12-2.png\" alt=\" \" border=\"0\" \/><\/a><br \/>\nPlease note that only Standard tier A4, A7, A8 and A9 and Basic Tier A4 are supported at this point and attempts to provision unsupported VM sizes will fail.<br \/>\n<a href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/5807.dpi-sep12-3.png\"><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/5807.dpi-sep12-3.png\" alt=\" \" border=\"0\" \/><\/a><\/li>\n<li>Wait for the provisioning to finish. While waiting, you can see the provisioning status on the virtual machines page (as in the picture below). When the provisioning is finished, the status will be Running with a checkmark.<br \/>\n<a href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7823.dpi-sep12-4.png\"><img decoding=\"async\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7823.dpi-sep12-4.png\" alt=\" \" border=\"0\" \/><\/a><\/li>\n<\/ol>\n<p>Alternatively, you can use PowerShell Commandlet New-AzureQuickVM to create the VM. You will need to pass your cloud service name, VM name, image name, Admin user name and password and so on as parameters. A simple way is to obtain the image name is to use Get-AzureVMImage to list out all the available VM images.<\/p>\n<h2>What are the specific configurations included in the transactional\/DW images?<\/h2>\n<p>The optimization we include in the optimized images are based on the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/azure\/dn133149.aspx?WT.mc_id=Blog_SQL_Announce_Announce\">Performance Best Practices for SQL Server in Azure Virtual Machines<\/a>. Specifically, it includes:<\/p>\n<table style=\"width: 624px\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"102\"><b>\u00a0<\/b><\/td>\n<td valign=\"top\" width=\"151\"><b>\u00a0<\/b><\/td>\n<td colspan=\"2\" valign=\"top\" width=\"165\"><b>Transactional<\/b><\/td>\n<td valign=\"top\" width=\"206\"><b>DW<\/b><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"4\" valign=\"top\" width=\"102\">\n<p align=\"center\"><b>Disk\u00a0 configurations<\/b><\/p>\n<\/td>\n<td valign=\"top\" width=\"151\">Number of data disks attached<\/td>\n<td valign=\"top\" width=\"164\">15<\/td>\n<td colspan=\"2\" valign=\"top\" width=\"207\">15<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" valign=\"top\" width=\"151\">Storage spaces<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">\n<p>Two storage pools:<\/p>\n<p>&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 data pool with 12 data disks; fixed size 12 TB; Column = 12<\/p>\n<p>&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 log pool with 3 data disks; fixed size 3 TB; Column = 3<\/p>\n<p>One data disk remaining for the user to attach and determine the usage.<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" valign=\"top\" width=\"165\">Stripe size = 64 KB<\/td>\n<td valign=\"top\" width=\"206\">Stripe size = 256 KB<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"151\">Disk sizes, caching, allocation size<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">1 TB each, HostCache=None, NTFS Allocation Unit Size = 64KB<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"6\" valign=\"top\" width=\"102\">\n<p align=\"center\"><b>SQL Configurations<\/b><\/p>\n<p><b>\u00a0<\/b><\/td>\n<td valign=\"top\" width=\"151\">Startup Parameters<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">\n<p>-T1117 to help keep data files the same size in case DB needs to autogrow<\/p>\n<p>-T1118 to assist in TEMPDB scalability (See <a href=\"http:\/\/blogs.msdn.com\/b\/psssql\/archive\/2008\/12\/17\/sql-server-2005-and-2008-trace-flag-1118-t1118-usage.aspx?WT.mc_id=Blog_SQL_Announce_Announce\">here<\/a> for more details)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"151\">Recovery Model<\/td>\n<td colspan=\"2\" valign=\"top\" width=\"165\">No change<\/td>\n<td valign=\"top\" width=\"206\">Set to \u201cSIMPLE\u201d for MODEL database using ALTER DATABASE<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"151\">Setup default locations<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">Move SQL Server error log and trace file directories to data disks<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"151\">Default locations for databases<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">\n<p>System databases moved to data disks.<\/p>\n<p>The location for creating user databases changed to data disks.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"151\">Instant File Initialization<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">Enabled<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"151\">Locked pages<\/td>\n<td colspan=\"3\" valign=\"top\" width=\"371\">Enabled (See <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms190730.aspx?WT.mc_id=Blog_SQL_Announce_Announce\">here<\/a> for more details)<\/td>\n<\/tr>\n<tr>\n<td width=\"121\"><\/td>\n<td width=\"146\"><\/td>\n<td width=\"159\"><\/td>\n<td width=\"1\"><\/td>\n<td width=\"197\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>FAQ<\/h2>\n<ul>\n<li>Any pricing difference between the optimized images and the non-optimized ones?<br \/>\nNo. The new optimized images follow exactly the same pricing model (details <a href=\"http:\/\/azure.microsoft.com\/en-us\/pricing\/details\/virtual-machines\/#sql-server?WT.mc_id=Blog_SQL_Announce_Announce\">here<\/a>) with no additional cost. Note that with larger VM instance sizes, higher cost is associated.<\/li>\n<li>Any other performance fixes I should consider:<br \/>\nYes, consider applying relevant performance fixes for SQL Server<\/p>\n<ul>\n<li><a href=\"http:\/\/support.microsoft.com\/kb\/2958012\/en-us?WT.mc_id=Blog_SQL_Announce_Announce\">Fix for poor performance on I\/O when you execute select into temporary table statement in SQL Server 2012<\/a><\/li>\n<li><a href=\"http:\/\/support.microsoft.com\/kb\/2973444\/en-us?WT.mc_id=Blog_SQL_Announce_Announce\">SQL Server performance counters are disabled&#8221; when you move the SQL Server resource in SQL Server 2014<\/a><\/li>\n<\/ul>\n<\/li>\n<li>How can I find more information on Storage Spaces?<br \/>\nFor further details on Storage Spaces, please refer to <a href=\"http:\/\/social.technet.microsoft.com\/wiki\/contents\/articles\/11382.storage-spaces-frequently-asked-questions-faq.aspx?WT.mc_id=Blog_SQL_Announce_Announce\">Storage Spaces Frequently Asked Questions (FAQ)<\/a>.<\/li>\n<li>What is the difference between the new DW image and the previous one?<br \/>\nThe previous DW image requires customers to perform additional steps such as attaching the data disks post VM creation while the new DW image is ready for use upon creation so it is more streamlined and less error prone.<\/li>\n<li>What if I need to use the previous DW image? Is there any way I can access it?<br \/>\nThe previous VM images are still available, just not directly accessible from the gallery. Instead, you can continue using Powershell commandlets. For instance, you can use Get-AzureVMImage to list out all images and once you locate the previous DW image based on the description and publish date, you can use New-AzureVM to provision it accordingly.<\/li>\n<\/ul>\n<p>Let your colleagues know about the New VM Images available by sharing via your preferred social channels and don\u2019t forget to follow <a href=\"https:\/\/twitter.com\/SQLServer\">@SQLServer<\/a> on Twitter and find <a href=\"https:\/\/www.facebook.com\/sqlserver\">SQL Server on Facebook<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are delighted to announce the release of new optimized SQL Server images in the Microsoft Azure Virtual Machines Gallery. These images are pre-configured with optimizations for transactional and Data Warehousing workloads respectively by baking in our performance best practices for running SQL in Azure VMs.<\/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":[2448],"topic":[],"coauthors":[2487],"class_list":["post-753","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-3-1593580441-293","review-flag-new-1593580247-437","review-flag-vm-1593580806-223"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery - 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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are delighted to announce the release of new optimized SQL Server images in the Microsoft Azure Virtual Machines Gallery. These images are pre-configured with optimizations for transactional and Data Warehousing workloads respectively by baking in our performance best practices for running SQL in Azure VMs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\" \/>\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-12T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:48:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-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=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery\",\"datePublished\":\"2014-09-12T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\"},\"wordCount\":864,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\",\"name\":\"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png\",\"datePublished\":\"2014-09-12T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/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":"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery - 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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/","og_locale":"en_US","og_type":"article","og_title":"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery - Microsoft SQL Server Blog","og_description":"We are delighted to announce the release of new optimized SQL Server images in the Microsoft Azure Virtual Machines Gallery. These images are pre-configured with optimizations for transactional and Data Warehousing workloads respectively by baking in our performance best practices for running SQL in Azure VMs.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2014-09-12T16:00:00+00:00","article_modified_time":"2024-01-23T06:48:48+00:00","og_image":[{"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-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":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery","datePublished":"2014-09-12T16:00:00+00:00","dateModified":"2024-01-23T06:48:48+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/"},"wordCount":864,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/","name":"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png","datePublished":"2014-09-12T16:00:00+00:00","dateModified":"2024-01-23T06:48:48+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/2438.dpi-sep12-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2014\/09\/12\/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=753"}],"version-history":[{"count":0,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/753\/revisions"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=753"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=753"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=753"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=753"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=753"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}