• Online, Self-Paced
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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.