Performance Tuning


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisites
None

Expected Duration (hours)
2.1

Lesson Objectives

Performance Tuning

  • 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
  • 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
  • describe the benefits of using extended events
  • describe extended events tasks
  • differentiate between extended events packages, targets, and sessions
  • distinguish between extended events targets
  • 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
  • using various tools to monitor performance

    • Course Number:
    df_sqld_a10_it_enus

    Expertise Level
    Expert