SQL_Server_2016_Mission_Critical_Performance_White_Paper.pdf

(1648 KB) Pobierz
Mission-Critical Performance
Technical White Paper
Published:
March 2016
Applies to:
Microsoft SQL Server 2016
Summary:
As the volume and complexity of data continue to increase, organizations require a new
approach to their mission-critical capabilities. This white paper examines how capabilities built into
Microsoft SQL Server—including enterprise-grade performance, security, availability, and scalability—
define a “new mission critical” that answers what kinds of capabilities organizations need to compete in a
dynamic global landscape.
Copyright
The information contained in this document represents the current view of Microsoft Corporation on the
issues discussed as of the date of publication. Because Microsoft must respond to changing market
conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft
cannot guarantee the accuracy of any information presented after the date of publication.
This white paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS,
IMPLIED, OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights
under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval
system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or
otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property
rights covering subject matter in this document. Except as expressly provided in any written license
agreement from Microsoft, the furnishing of this document does not give you any license to these
patents, trademarks, copyrights, or other intellectual property.
© 2016 Microsoft Corporation. All rights reserved.
Microsoft, Active Directory, Microsoft Azure, Excel, SharePoint, SQL Server, Windows, and Windows Server
are trademarks of the Microsoft group of companies.
All other trademarks are property of their respective owners.
Page
2
Contents
Microsoft SQL Server evolution...................................................................................................... 5
Mission-critical performance with SQL Server ............................................................................ 7
Performance............................................................................................................................................................7
In-Memory Online Transaction Processing......................................................................................................................... 7
In-memory analytics ................................................................................................................................................................. 10
Real-time operational analytics ............................................................................................................................................ 12
Query-processing enhancements........................................................................................................................................ 14
Reduced database size and increased performance: data and backup compression ........................................ 15
Proactive troubleshooting and diagnostics: Performance Data Collector and Management Studio............ 15
New in SQL Server 2016........................................................................................................................................................... 16
Security .................................................................................................................................................................. 21
Secure by default: lowering vulnerability ........................................................................................................................... 21
New in SQL Server 2016...........................................................................................................................................................22
Enhanced in SQL Server 2016 ................................................................................................................................................27
Availability ............................................................................................................................................................ 29
High availability of mission-critical systems ......................................................................................................................29
AlwaysOn .....................................................................................................................................................................................29
New in SQL Server 2016........................................................................................................................................................... 31
Enhanced in SQL Server 2016 ................................................................................................................................................ 31
Online database operations ...................................................................................................................................................33
Predictable, efficient, and flexible data backups .............................................................................................................33
Scalability.............................................................................................................................................................. 34
Support for Windows Server Core ...................................................................................................................................... 34
Faster live migration ................................................................................................................................................................ 34
Live migration for non-clustered virtual machines .........................................................................................................35
Cluster-Aware Updating..........................................................................................................................................................35
Dynamic Quorum ......................................................................................................................................................................35
Enhanced in SQL Server 2016 ................................................................................................................................................35
Conclusion ........................................................................................................................................ 37
Page
3
More information ........................................................................................................................... 37
Feedback............................................................................................................................................................... 37
Page
4
Microsoft SQL Server evolution
By developing and enhancing new features, Microsoft SQL Server continues to evolve and stay ahead of
organizational data needs. Customers have responded to this evolution by showing confidence in using
SQL Server to manage their mission-critical data. Industry analysts have also responded positively. For
example, Gartner recently rated SQL Server as having the most complete vision of any operational
database management system (Figure 1).
Figure 1: Gartner Magic Quadrant for operational database management systems (2015)
In addition, SQL Server has consistently added groundbreaking functionality over the last 15 years (Figure
2).
Page
5

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin