{"id":468,"date":"2012-11-25T18:10:30","date_gmt":"2012-11-25T18:10:30","guid":{"rendered":"\/blogs\/glenn\/post\/Oracle-versus-Microsoft-on-Vaporware-Fantasies.aspx"},"modified":"2020-01-11T12:51:50","modified_gmt":"2020-01-11T20:51:50","slug":"oracle-versus-microsoft-on-vaporware-fantasies","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/","title":{"rendered":"Oracle versus Microsoft on Vaporware Fantasies"},"content":{"rendered":"

A couple of weeks ago, Oracle\u2019s SVP of Communications Bob Evans wrote a pretty inflammatory blog post<\/a> that was on ForbesBrandVoice, which seeks to \u201cconnect marketers to the Forbes audience\u201d. The original post was removed on November 20, so my link points to a cached copy. In the post, he calls the Microsoft Hekaton project vaporware. Quoting Oracle\u2019s Andy Mendelsohn: \u201cSince Microsoft has no competitive product on the market today, they\u2019ve invented this vaporware project \u2018Hekaton\u2019 as their response.\u201d Bob Evans goes on to say:<\/p>\n

\u201cEven if Microsoft is able to deliver that feature in the next 24-30 months, Mendelsohn said, the objective reality will be that Microsoft\u2019s in-memory database will be available on industry-standard hardware\u2014end of story. And that, way off in the year 2014 or 2015, will simply not match up even to what Oracle has today.\u201d<\/p><\/blockquote>\n

This article was noticed, and forwarded around in the SQL Server community, causing much amusement. Somewhat surprisingly, Microsoft\u2019s Nick King responded in a very forceful way with this blog post. Here is a small excerpt:<\/p>\n

\u201cSo I challenge Oracle, since our customers are increasingly looking to In-Memory technologies to accelerate their business. Why don\u2019t you stop shipping TimesTen as a separate product and simply build the technology in to the next version of your flagship database? That\u2019s what we\u2019re going to do.<\/p>\n

This shouldn\u2019t be construed as a \u201cknee-jerk\u201d reaction to anything Oracle did. We\u2019ve already got customers running \u2018Hekaton\u2019 today, including online gaming company Bwin, who have seen a 10x gain in performance just by enabling \u2018Hekaton\u2019 for an existing SQL Server application. As Rick Kutschera, IT Solutions Engineer at Bwin puts it, \u201cIf you know SQL Server, you know Hekaton\u201d. This is what we mean by \u201cbuilt in\u201d. Not bad for a \u201cvaporware\u201d project we just \u201cinvented\u201d.\u201d<\/p><\/blockquote>\n

As far as Hekaton goes, it is definitely not vaporware. I have been aware of it for quite some time, but I could not talk about it until Microsoft announced it and demonstrated<\/a> it at the PASS Summit 2012. Microsoft\u2019s Dave Campbell writes about it here. The fact that Microsoft has actual customers already using the technology means that it will likely show up sooner than Oracle expects (not that I have any inside knowledge about that).<\/p>\n

So what does this mean to you, as you are busy running your current SQL Server infrastructure?\u00a0 Well first of all, keep in mind that Hekaton is targeted at very volatile OLTP workloads, where people are running into high latch waits as they try to insert many tens of thousands of rows per second into a table. It will let you convert individual \u201chot\u201d tables into Hekaton tables that will have to fit into main memory on your database server. It is not clear yet how this will play with table partitioning. You will also be able to convert standard T-SQL stored procedures (that only use Hekaton tables) into compiled stored procedures that run much faster.<\/p>\n

Even though Microsoft has not officially announced it, you can bet that this will be an Enterprise Edition only feature. You should be looking at your server hardware to determine how old it is and how much RAM it can hold. You also should take a fresh look at server class DRAM pricing, which has fallen to extremely low levels. Server class RAM is really an amazing bargain! If you are running SQL Server Enterprise Edition, you don\u2019t want to skimp on your RAM.<\/p>\n

It is pretty common in the SQL Server community to use the DRAM pricing from crucial.com as a benchmark for server class DRAM pricing. Currently, 32GB DDR3 ECC DIMMs still have a very substantial price premium, being priced at about $47\/GB, while 16GB DDR3 ECC DIMMs are priced at about $15\/GB.\u00a0 8GB DDR3 ECC DIMMs are even more affordable at about $11\/GB, but their lower capacity makes them much less attractive for database servers when you are trying to maximize your total capacity.<\/p>\n

Current two-socket servers that use the Intel Sandy Bridge-EP platform have 24 DIMM slots so they can support 384GB of DDR3 ECC RAM using 16GB DIMMs. They also have PCI-E 3.0 support. It would only cost $5760.00<\/span><\/strong> to fully populate one of those model servers with (24) 16GB DIMMs. Based on TPC-E benchmark scores, Sandy Bridge-EP systems that have the Intel Xeon E5-2690 processor<\/a> have the best single-threaded performance and give the best price performance<\/a> for SQL Server 2012 OLTP workloads.<\/p>\n

I am predicting that we will see the follow-on Ivy Bridge-EP platform roll out in Q2 2013, with something like an Intel Xeon E5-2690 V2 processor. This should be pin-compatible with current Sandy Bridge-EP servers (such as the Dell PowerEdge R720 and the HP DL380 Gen 8), which will make them available in existing models even more quickly. By then, 32GB DRAM prices will probably be more affordable.\u00a0 Looking further into the future, the Intel Haswell-EP platform will probably be available by Q2 2014. It will be a full Tock release from Intel, so it will probably support even more memory with better memory controllers.<\/p>\n","protected":false},"excerpt":{"rendered":"

A couple of weeks ago, Oracle\u2019s SVP of Communications Bob Evans wrote a pretty inflammatory blog post that was on ForbesBrandVoice, which seeks to \u201cconnect marketers to the Forbes audience\u201d. The original post was removed on November 20, so my link points to a cached copy. In the post, he calls the Microsoft Hekaton project […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,21,31],"tags":[70],"class_list":["post-468","post","type-post","status-publish","format-standard","hentry","category-sql-server-hekaton","category-microsoft","category-sql-server-2012","tag-hekaton"],"yoast_head":"\nOracle versus Microsoft on Vaporware Fantasies - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Describes Oracle versus Microsoft vaporware controversy regarding Microsoft Hekaton\" \/>\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\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle versus Microsoft on Vaporware Fantasies - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Describes Oracle versus Microsoft vaporware controversy regarding Microsoft Hekaton\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-25T18:10:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-11T20:51:50+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/\",\"name\":\"Oracle versus Microsoft on Vaporware Fantasies - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2012-11-25T18:10:30+00:00\",\"dateModified\":\"2020-01-11T20:51:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Describes Oracle versus Microsoft vaporware controversy regarding Microsoft Hekaton\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle versus Microsoft on Vaporware Fantasies\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle versus Microsoft on Vaporware Fantasies - Glenn Berry","description":"Describes Oracle versus Microsoft vaporware controversy regarding Microsoft Hekaton","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\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/","og_locale":"en_US","og_type":"article","og_title":"Oracle versus Microsoft on Vaporware Fantasies - Glenn Berry","og_description":"Describes Oracle versus Microsoft vaporware controversy regarding Microsoft Hekaton","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/","og_site_name":"Glenn Berry","article_published_time":"2012-11-25T18:10:30+00:00","article_modified_time":"2020-01-11T20:51:50+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/","name":"Oracle versus Microsoft on Vaporware Fantasies - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2012-11-25T18:10:30+00:00","dateModified":"2020-01-11T20:51:50+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Describes Oracle versus Microsoft vaporware controversy regarding Microsoft Hekaton","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/oracle-versus-microsoft-on-vaporware-fantasies\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Oracle versus Microsoft on Vaporware Fantasies"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=468"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/468\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}