Database Instance Performance

SQL Server 2016    |    Intermediate
  • 15 Videos | 1h 32m 25s
  • Includes Assessment
  • Earns a Badge
Likes 57 Likes 57
SQL Server Resource Governor is a feature used to manage SQL Server workloads and resource consumption. Discover Resource Governor, and monitoring and troubleshooting tools to improve database performance.

WHAT YOU WILL LEARN

  • describe workloads
    manage workloads and system resource consumption using resource governor
    enable resource governor
    configure resource governor properties
    create a resource pool
    create a workload group
    disable resource governor
    optimize memory configuration
  • describe the data collector service for monitoring SQL Server 2016 databases
    enable and configure a management data warehouse for the data collector service
    configure a data collection
    monitor and diagnose scheduling and wait statistics using dynamic management objects
    troubleshoot storage, IO, and cache issues
    demonstrate how to monitor Azure SQL Database query plans
    demonstrate how to use the SQL Server Monitor

IN THIS COURSE

  • Playable
    1. 
    Workloads
    4m 12s
    UP NEXT
  • Playable
    2. 
    Resource Governor
    6m 49s
  • Locked
    3. 
    Enabling Resource Governor
    2m 31s
  • Locked
    4. 
    Configuring Resource Governor
    7m 26s
  • Locked
    5. 
    Creating a Resource Pool
    4m 41s
  • Locked
    6. 
    Creating a Workload Group
    9m 25s
  • Locked
    7. 
    Disabling Resource Governor
    3m 11s
  • Locked
    8. 
    Memory Configuration
    4m 38s
  • Locked
    9. 
    Data Collector
    7m 8s
  • Locked
    10. 
    Configuring the Management Data Warehouse
    4m 58s
  • Locked
    11. 
    Enabling a Data Collector
    6m 33s
  • Locked
    12. 
    Scheduling and Wait Statistics
    5m 30s
  • Locked
    13. 
    Troubleshooting Storage, IO, and Cache Issues
    6m 48s
  • Locked
    14. 
    Monitor Azure SQL Databases
    5m 23s
  • Locked
    15. 
    Exercise: Monitor Databases Using SQL Server Monitor
    6m 14s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 16 Likes 16  
Likes 34 Likes 34  
COURSE Encryption
Likes 96 Likes 96