Microsoft's SQL Server will have in-memory technology
Computerworld - Hoping to speed online transaction processing, Microsoft is adding in-memory features to its SQL Server relational database manager.
The next version of SQL Server will allow users to host database tables, or even entire databases, within a server's memory. "Any application that is throttled by the I/O of a hard disk would benefit" by having its data moved into memory, said Doug Leland, a general manager in Microsoft's server and tools business.
The company is testing the technology, code-named Hekaton, with a number of its customers.
By holding a database table in memory, a server can execute transactions that use that table much more quickly, because it doesn't have to read data from nor write data to a disk. Microsoft predicts that its in-memory technology can run transactions 50 times faster than a standard SQL Server setup can.
To ease deployments, the next version of SQL Server will include a tool that allows database administrators to designate databases or individual tables that can be run in memory. No changes will be required of the applications that use the databases, Leland said.
Oracle's Exadata and SAP's HANA include in-memory support.
This version of this story was originally published in Computerworld's print edition. It was adapted from an article that appeared earlier on Computerworld.com.
Read more about Applications in Computerworld's Applications Topic Center.
- A Modern Approach to the Data Deluge Read this whitepaper to learn how infrastructure leaders can confidently manage cost, complexity, and risk, capitalize on emerging technologies, and drive future innovation...
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- Enable secure remote access to 3D data without sacrificing visual perfomance Design and manufacturing companies must adapt quickly to the demands of an increasingly global and competitive economy. To speed time to market for...
- The Truth About Virtual Computing for CAD If you're a user of graphics-intensive software such as 3D modeling, simulation and analysis, and visualization, you might be skeptical about moving to...
- Leveraging Flash Storage to Accelerate Oracle Real Application Clusters Join this webinar to understand the latest solid-state storage trends, the specific applications driving solid-state storage deployments and the benefits of deploying the...
- What should I look for in a Next Generation Firewall? SANS Provides Guidance With so many vendors claiming to have a Next Generation Firewall (NGFW), it can be difficult to tell what makes each one different.... All Databases White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!