Summary of key features of SQL Server 2016 CTP2.3 _mssql

SQL Server 2016 brings a new breakthrough in-memory performance and analytics to achieve mission-critical processing. Comprehensive security features-always Encrypted technology can help protect your data

Database Enhancements

Row level security has supported in-memory OLTP tables. Users can now implement the Row-level security policy on the memory tuning table.

In addition, schemabinding, predicate functions, and inline table-valued functions include native_compilation compilation options.

UDFs user-defined functions that use the native_compilation compilation option can be used in local modules and in exchange queries, just like memory tuning tables and disk tables.

UDFs user-defined functions that do not use the native_compilation compilation option can use only exchange queries.

In-memory OLTP has supported the following built-in security functions, increasing support for RLS

Is_member ({' Group ' | ' Role '} is_rolemember ("Role"
[, ' Database_principal '])
is_srvrolemember (' role ' [, ' Login '])
Original_ LOGIN ()
session_user
current_user
suser_id ([' Login '])
suser_sid ([' Login '] [, Param2])
Suser_ Sname ([server_user_sid])
system_user
suser_name
user
user_id ([' User '])
user_name ([ID] )
context_info ()

Another core engine extension upgrade is a dynamically partitioned thread-safe memory object based on a NUMA node or CPU

This improvement will enable a higher parallel load to be met on NUMA hardware. The thread-Safe Memory object (type Cmemthread) dynamically promotes the partitioning of NUMA nodes or CPUs based on load characteristics and contention.

In SQL2012 and SQL2014, you need to turn on the trace flag TF 8048来 the memory object in the partition node in the raised CPU partition. This improvement does not require tracking flags, and can dynamically adjust partitions based on CPU contention.

CTP2.3 contains performance optimizations for the In-memory Data Warehouse (columnstore), Ncci can now be created via triggers, or it can be used with CDC and change tracking (changing tracking).

To better analyze the column storage index, three columns were added to the sys.dm_db_column_store_row_group_physical_stats DMV:

Transition_to_compressed_state,transition_to_compressed_state_desc,has_vertipaq_optimization

Nonclustered Columnstore Index (NCCI)
Clustered columnstore Index (CCI)

Enhancements to SQL Server Analysis Service (SSAS)

Dax query performance upgrade, optimize tabular engine. ‘

Directquery enhancements, Directquery can now generate simpler queries with better performance.

Dax supports variables, which can store the result of an expression as a named variable, so you can pass a parameter to another measure expression.

Once the result value of the variable expression is evaluated, the value is not changed, even if the variable references another expression.

Enhancements to SQL Server Reporting Services (SSRS)

The modern theme has been included in the builder.

For the latest browsers, report rendering has supported the HTML5 standard.

Enhancements to SQL Server integration Service (SSIS)

OData V4 protocol support, SSIS Error column support, advanced log level support.

The SSIS directory previously provided only four log levels: None, Basic, performance, Verbose

The new advanced log level removes the previously inflexible log level

New mechanism: Event context can be collected when events are triggered

New Ssis_logreader role, allowing access to all view-related SSISDB action logs

New log customization level definition log and Events collection

Allow collection of event contexts, such as variable values, task properties, connection strings

Enhancements to Master Data Service (MDS)

Three attributes added

Many to Many hierarchy of inheritance

Excel plug-ins for Business rule management

Merge conflicts

Enhancements to query execution

Enhanced memory Grant usage (Memory grant usage) diagnostics

Added the following extended event xevents to better diagnose memory grant usage and problems.

Showplan XML adds memory grant usage extensions for each thread and iterator (in Runtimecountersperthread node)

Query_memory_grant_blocking
query_memory_grant_resource_semaphores
query_memory_grant_usage (Details on Ideal vs granted vs used memory)

DBCC CHECKDB Enhancements

1, verify the persisted computed column and the filtering index

2, when verifying a large table with thousands of partitions, the DBCC CHECKDB performance improvement, speed will be accelerated

The above is to introduce you to the SQL Server 2016 CTP2.3 key characteristics of the summary, I hope you like, small article will give you introduce SQL Server 2016 tempdb in a significant upgrade, the need for friends click to view.