Performance Tuning

Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisite
None

Expected Duration
127 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.