It is important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. This course provides and introduction for both the SQL Server platform and SQL Server architecture, while also providing an overview of best practices and guidelines to follow when preparing for an installation of SQL Server 2016. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.
Learning Objectives
SQL Server Platform
- start the course
- recognize the SQL Server 2016 components
- describe SQL Server 2016 instances
- describe SQL Server 2016 editions
- describe SQL Server versions
- explain SQL Server 2016 32-bit systems
- explain SQL Server 2016 64-bit systems
SQL Server Architecture
- recognize the different SQL Server 2016 architecture layers
- explain SQL Server 2016 CPU usage
- explain SQL Server 2016 Server memory management
- describe parallelism in SQL Server 2016
- explain I/O operations in SQL Server 2016
- describe the various services used by SQL Server 2016
- describe the various account types available in SQL Server 2016
- explain the different network protocols supported by SQL Server 2016
Best Practices for Installation
- understand the various hardware requirements for SQL Server 2016
- understand the various software requirements for SQL Server 2016
- describe considerations when implementing I/O subsystems for SQL Server 2016
- demonstrate how to use the SQLIOSim tool in SQL Server 2016
- demonstrate how to use the Diskspd tool in SQL Server 2016
Practice: Installation Prerequisites
- determine the requirements for a successful SQL Server deployment