SQL Server 2014 CTP2 released
At the PASS 2013 conference, Microsoft Vice President Quentin Clark announced the availability of the second preliminary release of the Customer Technology Preview (CTP2) of the next version of the Microsoft SQL Server 2014 database server.
It is noted that this preliminary release is complete in its functionality, i.e. no major innovations in the final release compared with him is not planned to add. Major innovations include:
• Support in-memory OLTP (Hekaton)
SQL Server 2014 will have the ability to host tables and stored procedures in RAM, which will allow to achieve a significant gain in the performance of transactional applications.
• Updated column indexes
Column indices are mainly used in analytical applications. They allow you to significantly speed up the execution of queries on data schemes specific to OLAP (star, snowflake). The column indexes are already used in the current version of SQL Server 2012 in read-only mode. In the 2014 version, this restriction will be removed, and column indices will be able to be updated when changes are made to the data, like traditional indexes.
')
• New type of managed resource in Resource Governor
The resource controller is used to divide the computing power of the computer between different applications accessing SQL Server, which makes it possible to prioritize the load and also ensures that the application does not go beyond the resources assigned to it, taking everything that is allocated to the database server. This allows for predictable performance. In previous versions, resources included memory and processor time. In the future version I / O will be added to them.
• Improved resiliency
The AlwaysOn High Availability group now includes 8 secondary replicas (versus 4 in the current version).
Support for Windows Cluster Shared Volumes.
• Cloud Integration
Ability to host large-size database files for on-premise SQL Server in Windows Azure, as well as perform backups in Windows Azure, including with new encryption features.
You can learn more about the new features of SQL Server 2014 and download STR2 here .
It is noted that this preliminary release is complete in its functionality, i.e. no major innovations in the final release compared with him is not planned to add. Major innovations include:
• Support in-memory OLTP (Hekaton)
SQL Server 2014 will have the ability to host tables and stored procedures in RAM, which will allow to achieve a significant gain in the performance of transactional applications.
• Updated column indexes
Column indices are mainly used in analytical applications. They allow you to significantly speed up the execution of queries on data schemes specific to OLAP (star, snowflake). The column indexes are already used in the current version of SQL Server 2012 in read-only mode. In the 2014 version, this restriction will be removed, and column indices will be able to be updated when changes are made to the data, like traditional indexes.
')
• New type of managed resource in Resource Governor
The resource controller is used to divide the computing power of the computer between different applications accessing SQL Server, which makes it possible to prioritize the load and also ensures that the application does not go beyond the resources assigned to it, taking everything that is allocated to the database server. This allows for predictable performance. In previous versions, resources included memory and processor time. In the future version I / O will be added to them.
• Improved resiliency
The AlwaysOn High Availability group now includes 8 secondary replicas (versus 4 in the current version).
Support for Windows Cluster Shared Volumes.
• Cloud Integration
Ability to host large-size database files for on-premise SQL Server in Windows Azure, as well as perform backups in Windows Azure, including with new encryption features.
You can learn more about the new features of SQL Server 2014 and download STR2 here .
Source: https://habr.com/ru/post/198380/
All Articles