Geek Sync Webcast : Need for Speed: In-Memory Databases in Oracle and SQL Server

Presenter: Vicky Harp & Bert Scalzo
Share This:  Facebook Twitter LinkedIn Google+

View this Geek Sync webinar with Vicky Harp and Bert Scalzo as they talk about the relationship between SQL Server and Oracle.

Microsoft introduced IN-MEMORY OLTP, widely referred to as "Hekaton" in SQL Server 2014. Hekaton allows for the creation of fully transactionally consistent memory-resident tables designed for high concurrency and no blocking. With SQL 2016, many of the original restrictions and limitations of this feature have been reduced. IDERA's Vicky Harp will give an overview of this feature, including how to compile T-SQL code into machine code for an even greater performance boost.

There's also been a lot of buzz about Oracle 12c's new IN-MEMORY COLUMN STORE. Oracle ACE Bert Scalzo will cover this new feature, how it works, it's benefits, scripts to measure/monitor it and more. He will also touch on performance observations from benchmarking this new feature against more traditional SGA memory allocations plus Oracle 11g R2's Database Smart Flash Cache. All findings, scripts and conclusions from this exercise will be shared. In addition, two very popular database benchmarking tools will be highlighted.

About Vicky:

With 14 years of professional software development experience, Vicky is always interested in learning new ways to improve performance and maintainability of database code. Vicky is a product manager with Idera, where she has worked for the past 10 years creating software to make DBAs' lives easier. She speaks frequently at PASS events and is active on Twitter.

About Bert:

Bert Scalzo is an Oracle® ACE, author, speaker, consultant, and is the Senior Product Manager at IDERA. He has three decades of Oracle® database experience and previously worked for both Oracle Education and Oracle Consulting. Bert’s areas of interest include data modeling, database benchmarking, database tuning and optimization, "star schema" data warehouses, Linux® and VMware®.

Register for Free Webcast
*
*
*
*
*