Performance improvements of SQL Server 2014 over SQL Server 2008

-



Following is the list of performance and scalability differences between SQL Server 2014 and SQL Server 2008 (ref. Technet). The most important feature is called in-memory OLTP. You can download and read the white paper (.pdf) from here, which describes the internals of in-memory OLTP.

PERFORMANCE and SCALE
  • In-Memory OLTP
  • Enhanced In-Memory ColumnStore for DW
  • Support for 640 logical proc. & 4 TB memory
  • Support to 15,000 partitions
  • Resource Governor IO governance
  • Buffer Pool Extension to SSDs
  • Query optimization enhancements
  • SysPrep at cluster level
  • Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2
  • Data Compression with USC-2 Unicode support
  • Backup Compression

Comments

Post a Comment

Popular posts from this blog

Space Character Problem on IE 6, 7, and 8

-
Most of the time, we need to put space in between two HTML elements to separate them. There are bunch of ways to achieve this but the following are the most common ones that I use: Space character ( ) CSS Margin (margin-right/margin-left) Space character is so natural separate them but CSS margin gives more flexibility. Also recently, I found out that in IE 6, 7, 8, extra space characters between HTML elements are not rendered as intended. For instance regular space character ( ) is rendered without the space on older version of IE (older than 9) a   b Result in IE 6, 7, 8: ab Whereas, if you use CSS (e.g. margin-right: 4px), all versions of IE renders it correctly a b Result in all IEs: a b
Read more

Does Netflix work on iOS 5 Beta 4?

-
Yes, finally Netflix works on iOS 5 Beta 4!! Two days ago I updated Netflix to a new version and boom it not works on iOS 5 now. But in my opinion iOS 5 is still not ready for a release to public. Here is the latest bug I faced with; After my update to iOS 5 Beta 4, alarm clock on the phone did not work! I had to reset the alarm clock to make it working again, huh.
Read more

AWS encryption chart (SSE-S3 vs SSE-KMS vs SSE-C)

-
IN TRANSIT AT REST SSL/TLS Server Side Managed Keys Client Side Managed Keys S3 (SSE-S3) Each object is encrypted with a key. Amazon encrypts the key with a master key, which rotates regularly. AWS Key Management Service (SSE-KMS) Allows you to audit trail (who and when used the key), extra cost and you manage the master key. Customer provided (SSE-C) User manages the keys but encryption done by Amazon User encrypts the data on client-side and uploads to S3
Read more