{"id":2873,"date":"2012-12-11T09:00:00","date_gmt":"2012-12-11T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/12\/11\/how-fast-is-project-codenamed-hekaton-its-wicked-fast\/"},"modified":"2024-01-22T22:49:27","modified_gmt":"2024-01-23T06:49:27","slug":"how-fast-is-project-codenamed-hekaton-its-wicked-fast","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/11\/how-fast-is-project-codenamed-hekaton-its-wicked-fast\/","title":{"rendered":"How Fast is Project Codenamed \u201cHekaton\u201d \u2013 It\u2019s \u2018Wicked Fast\u2019!"},"content":{"rendered":"
Recently I posted a <\/span>video<\/span><\/a> about how the SQL Server Community was looking into emerging trends in BI and Database technologies – one of the key technologies mentioned in that video was in-memory.<\/span><\/p>\n Many Microsoft customers have been using <\/span>in-memory technologies<\/span><\/a> as part of SQL Server since 2010 including xVelocity Analytics, xVelocity Column Store and Power Pivot, something we recently covered in a <\/span>blog post<\/span><\/a> following the \u2018vaporware\u2019 outburst from Oracle SVP of Communications, Bob Evans. Looking forward, Ted Kummert recently <\/span>announced<\/span><\/a> project codenamed \u201cHekaton,\u201d available in the next major release of SQL Server. \u201cHekaton\u201d will provide a full in-memory transactional engine, and is currently in private technology preview with a small set of customers. This technology will provide breakthrough performance gains of up to 50 times.<\/span><\/p>\n For those who are keen to get a first view of customers using the technology, below<\/span> is the video of online gaming company bwin using \u201cHekaton\u201d. <\/span><\/p>\n Bwin is the largest regulated online gaming company in the world, and their success depends on positive customer experiences. They had recently upgraded some of their systems to SQL Server 2012 – a story you can read <\/span>here<\/span><\/a>. Bwin had already gained significant in-memory benefit using xVelocity Column Store, for example \u2013 a large report that used to take 17 minutes to render now takes only three seconds.<\/span><\/p>\n Given the benefits, they had seen with in-memory technologies, they were keen to trial the technology preview of \u201cHekaton\u201d. Prior to using \u201cHekaton\u201d, their online gaming systems were handling about 15,000 requests per second, a huge number for most companies. However, bwin needed to be agile and stay at ahead of the competition and so they wanted access to the latest technology speed. <\/span><\/p>\n Using \u201cHekaton\u201d bwin were hoping they could at least double the number of transactions. They were \u2018pretty amazed\u2019 to see that the fastest tests so far have scaled to 250,000 transactions per second.<\/span><\/p>\n So how fast is \u201cHekaton\u201d \u2013 just ask Rick Kutschera, the Database Engineering Manager at bwin \u2013 in his words it\u2019s \u2018Wicked Fast\u2019! However, this is not the only point that Rick highlights, he goes on to mention that \u201cHekaton\u201d integrates seamlessly into the SQL Server engine, so if you know SQL Server, you know \u201cHekaton\u201d. <\/span><\/p>\n — David Hobbs-Mallyon, Senior Product Marketing Manager<\/em><\/p>\n \u00a0<\/p>\n