Database Reference
In-Depth Information
Summary
In this chapter, we have discussed some of the new performance features of
SQL Server 2014 that can help improve your database performance. We looked
at partition switching and indexing, discussed some of the improvements in
columnstore indexing, and looked at the enhancements in the Resource Governor
and how changes to the cardinality estimator work. Hopefully, there is something
that you can make use of from these improvements in your databases to improve
their performance. As you can see, SQL Server 2014 has some great new features
for the DBA. These new features will allow the DBA to implement a more robust
and highly available production environment. The enhancements and changes to
some of the SQL Server performance features, namely In-Memory Optimized tables
and Delayed Durability, provide the DBA with an additional set of tools to get their
databases performing at an optimal level.
