SQL Server® 2014 Community Technology Preview 1

Posted By: Balvir Chand - 10/06/2013 12:42:00 pm
SQL Server 2014 promises a new in-memory capability for tables that can fit entirely in memory (also known as Hekaton). Whilst small tables may be entirely resident in memory in all versions of SQL Server, they also may reside on disk, so work is involved in reserving ram, writing evicted pages to disk, loading new pages from disk, locking the pages in ram while they are being operated on, and may other tasks. By treating a table as guaranteed to be entirely resident in memory much of the 'plumbing' of disk-based databases can be avoided.
For disk-based SQL Server applications, it also provides SSD bufferpool extension, which can improve application performance transparently by leveraging SSD as the intermediate memory hierarchy between DRAM and spinning media.
SQL Server 2014 also enhances AlwaysOn (HADR) solution by increasing the readable secondaries count and sustaining read operations upon secondary-primary disconnections, and it provides new hybrid disaster recovery and backup solutions with Windows Azure, enabling customers to use their existing skills with the on-premises product offerings to take advantage of Microsoft’s global datacenters. In addition, it takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities for database application scalability in a physical or virtual environment.
source:-Wikipedia
Download Here

Share

& Comment

0 comments:

Post a Comment

Don't be shy: leave your comments!

Download It from Here

Designed by: Templatezy