SQL Server 2014 In-Memory
April 1, 2014 – SQL Server 2014 with built-in in-memory technology can accelerate your business and enable new scenarios that make you more competitive. Here are some key things you should know about in-memory technology in SQL Server 2014 and how it can benefit your organization.
- It’s built-in.
- If you know SQL, you know how to use our in-memory technology.
- It’s not a separate database product, and there are no new APIs to learn.
- You can take advantage of other powerful SQL Server features such as AlwaysOn as well as in-memory capabilities.
- You don’t need to buy multiple product SKUs – the SQL Server 2014 Enterprise SKU gives you in-memory capabilities across OLTP, DW, and analytics.
- It’s flexible – run in-memory tables alongside traditional tables on disk.
- We don’t believe having to load the entire database into memory is an optimal architecture, as putting cold data into memory doesn’t help. SQL Server 2014 allows you to select the most utilized tables and have them reside in memory. This means you can significantly improve your transactional performance without having to refresh hardware.
- We even provide tools built right into SSMS that let you know the optimal tables and stored procedures to migrate to memory.
- You can query both traditional on-disk tables and in-memory tables through a single query.
- It’s pervasive across all SQL Server workloads.
- SQL Server 2014 is the third release of our in-memory technology, which started back in SQL Server 2008 R2 with in-memory analytics. Then in SQL Server 2012, we added in-memory capabilities for data warehousing with an in-memory ColumnStore. Now with SQL Server 2014, you also have in-memory OLTP and an enhanced in-memory ColumnStore that is now updatable and offers much higher data compression.
- This means we can uniquely speed your transactions, queries, and analytics.
- It lets you remove database contention and utilize CPU and Core capacity.
- SQL Server 2014 has a unique in-memory OLTP design point of removing contention in the database by removing locks and latches and still ensuring 100% durability. You can learn more about this unique architecture by watching David DeWitt’s PASS Summit 2013 keynote.
- This means much higher throughput and speed of transactions as well as much lower latency. You can now harness the full power of your CPUs.
SQL Server 2014 provides breakthrough performance for all your mission-critical workloads. If you haven’t already, please download the evaluation copy of SQL Server 2014 and see for yourself the performance gains that in-memory technology provides for your applications. If you want to dev/test SQL Server 2014 quickly and efficiently, you can spin up an image of SQL Server 2014 in minutes in a Microsoft Azure Virtual Machine.