Database Instance Performance

SQL Server 2016    |    Intermediate
  • 15 videos | 1h 25m 25s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 47 users Rating 4.7 of 47 users (47)
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

  • 4m 12s
    After watching this video, you will be able to describe workloads. FREE ACCESS
  • 6m 49s
    Learn how to manage workloads and system resource consumption using the resource governor. FREE ACCESS
  • Locked
    3.  Enabling Resource Governor
    2m 31s
    Learn how to enable resource governor. FREE ACCESS
  • Locked
    4.  Configuring Resource Governor
    7m 26s
    This video will show you how to configure resource governor properties. FREE ACCESS
  • Locked
    5.  Creating a Resource Pool
    4m 41s
    In this video, you will create a resource pool. FREE ACCESS
  • Locked
    6.  Creating a Workload Group
    9m 25s
    In this video, you will create a work group. FREE ACCESS
  • Locked
    7.  Disabling Resource Governor
    3m 11s
    In this video, learn how to disable the resource governor. FREE ACCESS
  • Locked
    8.  Memory Configuration
    4m 38s
    In this video, you will learn how to optimize your memory configuration. FREE ACCESS
  • Locked
    9.  Data Collector
    7m 8s
    After completing this video, you will be able to describe the data collector service for monitoring SQL Server 2016 databases. FREE ACCESS
  • Locked
    10.  Configuring the Management Data Warehouse
    4m 58s
    In this video, find out how to enable and configure a management data warehouse for the data collector service. FREE ACCESS
  • Locked
    11.  Enabling a Data Collector
    6m 33s
    In this video, you will learn how to configure data collection. FREE ACCESS
  • Locked
    12.  Scheduling and Wait Statistics
    5m 30s
    In this video, you will learn how to monitor and diagnose scheduling and wait statistics using dynamic management objects. FREE ACCESS
  • Locked
    13.  Troubleshooting Storage, IO, and Cache Issues
    6m 48s
    In this video, you will troubleshoot storage, input/output, and cache issues. FREE ACCESS
  • Locked
    14.  Monitor Azure SQL Databases
    5m 23s
    In this video, you will learn how to monitor query plans for Azure SQL Database. FREE ACCESS
  • Locked
    15.  Exercise: Monitor Databases Using SQL Server Monitor
    6m 14s
    In this video, you will learn how to use the SQL Server Monitor. 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

Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course Leveraging the Power of Performance Management
Rating 4.7 of 164 users Rating 4.7 of 164 users (164)
Book Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Normalization Concepts & Forms
Rating 4.7 of 164 users Rating 4.7 of 164 users (164)
Course Memory-optimized Tables & Native Stored Procedures
Rating 4.6 of 27 users Rating 4.6 of 27 users (27)
Course Designing & Implementing Views
Rating 4.6 of 70 users Rating 4.6 of 70 users (70)