Performance Metrics

SQL Server 2016    |    Intermediate
  • 12 Videos | 1h 15m 51s
  • Includes Assessment
  • Earns a Badge
Likes 34 Likes 34
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

  • Playable
    1. 
    Performance Metrics
    5m 51s
    UP NEXT
  • Playable
    2. 
    Performance Baseline
    3m 38s
  • Locked
    3. 
    Performance Monitor
    7m 51s
  • Locked
    4. 
    Dynamic Management Objects
    6m 55s
  • Locked
    5. 
    Troubleshooting Performance Issues
    6m
  • Locked
    6. 
    Azure SQL Database Performance
    6m 55s
  • Locked
    7. 
    Live Query Statistics
    4m 38s
  • Locked
    8. 
    Activity Monitor
    6m 57s
  • Locked
    9. 
    Task Manager
    3m 21s
  • Locked
    10. 
    DBCC Commands
    6m 19s
  • Locked
    11. 
    System Stored Procedures
    5m 41s
  • Locked
    12. 
    Exercise: Monitor Performance Using Monitoring Tools
    6m 17s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 26 Likes 26  
Likes 26 Likes 26  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 61 Likes 61  
Likes 26 Likes 26  
Likes 15 Likes 15