BEST OF THE WEB

New version of SQL Server has expanded in-memory capabilities

The latest version of Micrsosoft’s flagship database has in-memory capabilities across all data workloads.

SQL Server 2014, released Tuesday, delivers “breakthrough performance for applications in throughput and latency,” Quentin Clark president of the company’s data platform group, said in a blog.

“Our relational database in SQL Server has been handling data warehouse workloads in the terabytes to petabyte scale using in-memory columnar data management. In memory technology has been allowing users to manipulate millions of records at the speed of thought, and scaling analytics solutions to billions of records in SQL Server Analysis Services. memory technology has been allowing users to manipulate millions of records at the speed of thought, and scaling analytics solutions to billions of records in SQL Server Analysis Services.”

Microsoft executives talked about SQL Server at a customer event in San Francisco, where CEO Satya Nadella also announced the availability of the Analytics Platform System (APS), which combines SQL Server and Hadoop technology to offer what Microsoft calls “big data in a box.”

They also talked about the upcoming Windows Azure Intelligent Systems Service, a cloud service that captures and manages machine-generated data from sensors and devices connected to the Internet.

Microsoft also said that it has broken two records in TPC- H10 Terabyte and 3 TB benchmarks for non-clustered configurations in data warehouses using the new database running on HP servers:

–In the 10TB category, running on an HP ProLiant DL580 Gen8 Server and SQL Server 2014 Enterprise Edition the configuration handled 404,005 query-per-hour (QphH) topping the previously held record from Oracle/SPARC of 377,594 (QphH), Micrsoft said.

–In the 3 TB category the same configuration achieved 461,837 query-per-hour (QphH) topping the previously held record from Oracle/SPARC of 409,721  (QphH), Microsoft said.

The TCP-H Benchmark test is a suite of business-oriented ad-hoc queries and concurrent data modifications.

Among the new capabilities in SQL Server 2014 include a wizard that helps administrators move from on-premise to Windows Azure cloud service,  a buffer-pool extension to solid state hard drives for faster paging and improved security including  beefed up encryption.

 

Howard Solomon
Howard Solomon
Currently a freelance writer, I'm the former editor of ITWorldCanada.com and Computing Canada. An IT journalist since 1997, I've written for several of ITWC's sister publications including ITBusiness.ca and Computer Dealer News. Before that I was a staff reporter at the Calgary Herald and the Brampton (Ont.) Daily Times. I can be reached at hsolomon [@] soloreporter.com

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

ITW in your inbox

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

More Best of The Web