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.
- Five Steps to Achieve Success in your Application Security Program This white paper provides a general framework your organization can use to create or build upon an application security program. It includes guidelines...
- Unlock the Value of Enterprise Mobility Download this guide and learn how to manage the secure deployment of enterprise mobile apps and data, while still encouraging the levels of...
- Rebranded Quadmark revamps its IT solutions with Google Apps Switching to Google Apps halved Quadmark's IT admin costs while achieving 10% time savings per employee. The global consulting firm now spends 80%...
- Manufacturing Outlook: Improving time to market, operational effectiveness and innovation in a highly competitive environment An enterprise project portfolio management solution can help manufacturers position themselves in the new competitive landscape.
- Live Webcast
Transforming Finance, Procurement and Supply Chain Effectiveness with Cross-Functional Analytics
Date: May 6th, 2014
Time: 1 PM EDT
Attend this Webcast to find out how Oracle's packaged analytic applications enable line-of-business managers to examine all...
- Video Stream Quality Impacts Viewer Behavior This scientific white paper, using statistical data from Amakai's streaming network, analyzes how changes in video quality cause changes in viewer behavior.
- Service-Enabling CICS Applications: Best Practices This informative webcast provides an informed, thorough look into CICS service-enablement options and how they can affect your environment. You'll learn how to... All Applications White Papers | Webcasts