Performance Metrics

SQL Server 2016    |    Intermediate
  • 12 videos | 1h 10m 21s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance. Examine performance metrics and monitoring, and the various logging tools available with SQL Server.

WHAT YOU WILL LEARN

  • 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
    Using various tools to monitor performance

IN THIS COURSE

  • 5m 51s
    After watching this video, you will be able to describe performance metrics. FREE ACCESS
  • 3m 38s
    In this video, you will learn how to establish a server performance baseline. FREE ACCESS
  • Locked
    3.  Performance Monitor
    7m 51s
    In this video, you will learn how to use Performance Monitor. FREE ACCESS
  • Locked
    4.  Dynamic Management Objects
    6m 55s
    In this video, you will learn how to use dynamic management objects. FREE ACCESS
  • Locked
    5.  Troubleshooting Performance Issues
    6m
    Learn how to compare baseline metrics to observed metrics in order to troubleshoot performance issues. FREE ACCESS
  • Locked
    6.  Azure SQL Database Performance
    6m 55s
    Learn how to monitor performance of Azure SQL Database. FREE ACCESS
  • Locked
    7.  Live Query Statistics
    4m 38s
    In this video, you will learn how to enable and view live query statistics. FREE ACCESS
  • Locked
    8.  Activity Monitor
    6m 57s
    To find out how to use the activity monitor in SQL Server 2016, consult the documentation or ask a qualified person. FREE ACCESS
  • Locked
    9.  Task Manager
    3m 21s
    In this video, you will learn how to use the task manager windows monitoring tool. FREE ACCESS
  • Locked
    10.  DBCC Commands
    6m 19s
    In this video, you will learn how to execute database consistency checker commands. FREE ACCESS
  • Locked
    11.  System Stored Procedures
    5m 41s
    Learn how to use system stored procedures for monitoring purposes. FREE ACCESS
  • Locked
    12.  Exercise: Monitor Performance Using Monitoring Tools
    6m 17s
    During this video, you will learn how to use various tools to monitor performance. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Optimizing Statisitics & Indexes
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Course Stored Procedures
Rating 4.6 of 64 users Rating 4.6 of 64 users (64)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Analyzing Query Plans
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
Course Extended Events & SQL Trace
Rating 4.4 of 37 users Rating 4.4 of 37 users (37)
Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)