{"id":857,"date":"2009-05-17T16:40:00","date_gmt":"2009-05-17T16:40:00","guid":{"rendered":"\/blogs\/paul\/post\/Importance-of-choosing-the-right-architecture-and-SQL-Server-Edition.aspx"},"modified":"2017-04-13T09:54:09","modified_gmt":"2017-04-13T16:54:09","slug":"importance-of-choosing-the-right-architecture-and-sql-server-edition","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/","title":{"rendered":"Importance of choosing the right architecture and SQL Server Edition"},"content":{"rendered":"<p>\n<font face=\"verdana,geneva\" size=\"2\">Last week&#39;s survey was another two-fold one &#8211; when you buy new servers, what architecture to you predominantly buy, and why?; when you buy new servers, which Edition of SQL Server do you predominantly buy, and why? Here are the results as of 5\/17\/2009. <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg\" alt=\"\" width=\"576\" height=\"388\" \/>&nbsp; <img decoding=\"async\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvedition.jpg\" alt=\"\" width=\"577\" height=\"390\" \/> <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">For the first survey, the &#39;other&#39; values were basically that 64-bit is purchased only if required. For the second survey, nine of the &#39;other&#39; values were basically that Enterprise Edition is purchased only if required, one person uses Web Edition, and one person uses Developer Edition as they&#39;re just a developer. <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">I don&#39;t have a huge amount to say about these two surveys, I really just wanted to confirm my gut feel (and give you all a view of what&#39;s happening out there in the field). <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">For the architecture survey, I was entirely unsurprised to see that almost 80% of respondents are using 64-bit. It&#39;s widely known that 64-bit can give you better performance through the availability of more memory for SQL Server to use. Although you can use more than 4GB using AWE on 32-bit, that extra memory is only available for the buffer pool to use &#8211; not for general query processing &#8211; and AWE access does incur a little overhead. Much has been written about this and I&#39;m not going to duplicate it here. A selection of articles can easily be found at <\/font><a href=\"https:\/\/www.google.com\/search?hl=en&amp;q=sql+server+64+bit+vs+32+bit&amp;aq=1&amp;oq=sql+server+64&amp;gws_rd=ssl\"><font face=\"verdana,geneva\" size=\"2\">http:\/\/www.google.com\/search?hl=en&amp;q=sql+server+64+bit+vs+32+bit&amp;aq=1&amp;oq=sql+server+64<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">&nbsp; More&nbsp;interesting is the small number of respondents who are not able to use 64-bit, either because their corporate policy is 32-bit (maybe because of cost?), they have software that doesn&#39;t run on 64-bit systems, or specifically because 64-bit is too expensive. <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">A few people only use 64-bit if required, and (I imagine) prefer to save money if it not by sticking with 32-bit. I wonder how long it will be until 32-bit servers are not available at all? Certainly future versions of Microsoft server software are starting to become 64-bit only &#8211; for instance Exchange 2010 (see <\/font><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/aa996719(EXCHG.140).aspx\"><font face=\"verdana,geneva\" size=\"2\">here<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">) and SharePoint Server 2010 (see <\/font><a href=\"http:\/\/www.collabshow.com\"><font face=\"verdana,geneva\" size=\"2\">here<\/font><\/a><font face=\"verdana,geneva\" size=\"2\">), will the next version of SQL Server be 64-bit only? <\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">For the Edition survey, again, unsurprising results. 55% use Enterprise Edition for one or a combination of the various &quot;-abilities&quot; (if you make performancability a new word), with almost 10% more having the option to use it if required, and&nbsp;16% having to stay with Standard because of budgetary constraints. What you may be surprised to see (but I wasn&#39;t from my time working side-by-side with the SQL marketing team) is that 20% of respondents <em>don&#39;t need<\/em>&nbsp;Enterprise Edition. There were a lot of improvements to the database engine in SQL Server 2000 and SQL Server 2005 that meant that for intermediate workloads (hmm &#8211; just made that up, but you know what I&#39;m trying to say), Enterprise Edition isn&#39;t <em>needed<\/em>. And with synchronous database mirroring&nbsp;available in Standard Edition, you can implement a great, low-cost&nbsp;high-availability plan without paying for Enterprise. As you can see, I don&#39;t get any kickbacks from the SQL team for selling Enterprise Edition &nbsp;Saying that, however, there are a lot of very cool features in Enterprise Edition in the various versions &#8211; but if you don&#39;t *need* them, why pay for the higher Edition just for the sake of it?<\/font>\n<\/p>\n<p>\n<font size=\"2\">One thing I will say to summarize, it&#39;s important to look at your requirements in terms of performance, availability, etc to make the right choice of server architecture and SQL Server Edition. If you make the wrong choice, do you think your company will pay to rectify your mistake before the next round of capital-expenditure? Probably not &#8211; but you&#39;ll definitely pay for the wrong choice with several years worth of hassle trying to make the system be more performant and easily recoverable than your choices allow.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">As always, thanks for participating in the surveys &#8211; I&#39;ve had a bunch of mail from people who like to see what other people are doing.<\/font>\n<\/p>\n<p>\n<font face=\"verdana,geneva\" size=\"2\">Next up &#8211; this week&#39;s survey!<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last week&#39;s survey was another two-fold one &#8211; when you buy new servers, what architecture to you predominantly buy, and why?; when you buy new servers, which Edition of SQL Server do you predominantly buy, and why? Here are the results as of 5\/17\/2009. &nbsp; For the first survey, the &#39;other&#39; values were basically that [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,45,91],"tags":[],"class_list":["post-857","post","type-post","status-publish","format-standard","hentry","category-general","category-hardware","category-surveys"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importance of choosing the right architecture and SQL Server Edition - Paul S. Randal<\/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.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importance of choosing the right architecture and SQL Server Edition - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Last week&#039;s survey was another two-fold one &#8211; when you buy new servers, what architecture to you predominantly buy, and why?; when you buy new servers, which Edition of SQL Server do you predominantly buy, and why? Here are the results as of 5\/17\/2009. &nbsp; For the first survey, the &#039;other&#039; values were basically that [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2009-05-17T16:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:54:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/\",\"name\":\"Importance of choosing the right architecture and SQL Server Edition - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg\",\"datePublished\":\"2009-05-17T16:40:00+00:00\",\"dateModified\":\"2017-04-13T16:54:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importance of choosing the right architecture and SQL Server Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importance of choosing the right architecture and SQL Server Edition - Paul S. Randal","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.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/","og_locale":"en_US","og_type":"article","og_title":"Importance of choosing the right architecture and SQL Server Edition - Paul S. Randal","og_description":"Last week&#39;s survey was another two-fold one &#8211; when you buy new servers, what architecture to you predominantly buy, and why?; when you buy new servers, which Edition of SQL Server do you predominantly buy, and why? Here are the results as of 5\/17\/2009. &nbsp; For the first survey, the &#39;other&#39; values were basically that [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/","og_site_name":"Paul S. Randal","article_published_time":"2009-05-17T16:40:00+00:00","article_modified_time":"2017-04-13T16:54:09+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg","type":"","width":"","height":""}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/","name":"Importance of choosing the right architecture and SQL Server Edition - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg","datePublished":"2009-05-17T16:40:00+00:00","dateModified":"2017-04-13T16:54:09+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2009\/5\/newsrvarch.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/importance-of-choosing-the-right-architecture-and-sql-server-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Importance of choosing the right architecture and SQL Server Edition"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=857"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/857\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}