SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SQL Server and T-SQL Development Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

Software Development



SQL Server 2014 In-Memory OLTP

Hi SQL developers and SQL Server database administrators,

I've started to study the new In-Memory OLTP enhancements introduced with Microsoft SQL Server 2014 CTP1. I must say that it was easy to start using in-memory optimized database and tables on my development and test laptop.

The table create syntax and the stored procedure syntax is showing different than as we get used to. But it is not hard to understand and use the new syntax for memory optimized tables and for natively compiled stored procedures.

As my first impression on the performance improvement that comes with SQL Server 2014 in-memory OLTP, I can easily say that it is great.
My dummy PC with not configured for SQL Server data tasks provided 1000000 rows insert into memory optimized database table in 4 seconds. On the other hand, it took about 75 times more time to insert 1 million records to a normal table stored on physical disk.

I'll be concentrating on in-memory optimized database enhancements of SQL Server 2014 more in coming days. So see you on my next post.
Update: For database administrators who requires a temporary memory resource tı support caching for minimizing IO reads and optimizing IO throughput, SQL Server 2014 introduces Buffer Pool Extension. Buffer pool extension enables administrators to add a SSD (Solid State Disk) or a flash disk for SQL Server engine to use as buffer pool to increase caching for reducing disk IO

Comments

No Comments
Anonymous comments are disabled

About eralper

SQL Server administrator and T-SQL developer including BI components Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form Siemens HiPath Center CTI development
Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems