Course Description
SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance for an environment. This course covers performance metrics and monitoring, as well as the various logging tools available with SQL Server, such as perfmon and dynamic management objects. In addition, this course covers Extended Events, and the event-handling system used for monitoring SQL Server instances. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Learning Objectives
SQL Server Performance
- start the course
- describe performance metrics
- establish a server performance baseline
- demonstrate how to use perfmon
- demonstrate how to use dynamic management objects
- compare baseline metrics to observed metrics in order to troubleshoot performance issues
- monitor Azure SQL Database performance
Monitoring Tools
- demonstrate how to enable and view live query statistics
- use the activity monitor in SQL Server 2016
- demonstrate how to use the task manager windows monitoring tool
- demonstrate how execute database consistency checker commands
- use system stored procedures for monitoring tasks
Extended Events
- describe the benefits of using extended events
- describe extended events tasks
- differentiate between extended events packages, targets, and sessions
- distinguish between extended events targets
SQL Trace
- describe the SQL trace architecture
- create a trace using transact-sql
- optimize SQL trace to minimize performance costs
- demonstrate how to schedule tracing in SQL Server
Practice: Monitoring Performance
- using various tools to monitor performance