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.
- How Four Citrix Customers Solved the Enterprise Mobility Challenge Managing mobile devices, data and all types of apps-Windows, datacenter, web and native mobile- through a single solution.
- 8 Steps to Fill the Mobile Enterprise Application Gap Traveling executives and Millennials alike expect to communicate, collaborate and access their important work applications and data from anywhere on whatever device they...
- Seattle Children's Accelerates Citrix Login Times by 500% with Cross-Tier Insight Seattle Children's is a leading research hospital with a large and growing Citrix XenDesktop deployment. With ExtraHop, the IT team at Seattle Children's...
- McKesson Makes Application Hosting for Hospitals Faster, More Efficient With ExtraHop, McKesson identified the root cause of slow Citrix XenApp application launches and adopted a more intelligent, proactive IT operations model that...
- Transform Your IT Service Management Watch this webinar, to learn how EasyVista can increase IT productivity & efficiency and deliver streamlined & integrated IT Service & Asset Mgmt.
- Responding to New SSL Cybersecurity Threat The featured Gartner research examines current strategies to address new SSL cybersecurity threats and vulnerabilities. All Applications White Papers | Webcasts