Monitoring Database Activity

SQL 2016    |    Intermediate
  • 10 Videos | 1h 1m 57s
  • Includes Assessment
  • Earns a Badge
Likes 26 Likes 26
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore managing and monitoring SQL Server database activity, including data collector and creating a utility control point.

WHAT YOU WILL LEARN

  • recognize the types of activities that can be monitored using Activity Monitor
    use Activity Monitor in SQL Server Management Studio to monitor database activity
    identify blocks using Activity Monitor and stored procedures
    describe the role of the Data Collector
    describe the components that make up the data collection system
  • configure the Data Collector
    use System Monitor to monitor resource usage
    describe the purpose of Utility Control Point and the requirements for its use
    use the Create UCP Wizard to create a SQL Server Utility Control Point
    complete the creation of a SQL Server Utility Control Point

IN THIS COURSE

  • Playable
    1. 
    Activity Monitor
    5m 27s
    UP NEXT
  • Playable
    2. 
    Using Activity Monitor in SSMS
    5m 52s
  • Locked
    3. 
    Identifying Blocks
    4m 55s
    FREE ACCESS
  • Locked
    4. 
    The Data Collector
    5m 8s
    FREE ACCESS
  • Locked
    5. 
    Data Collection Design
    3m 44s
    FREE ACCESS
  • Locked
    6. 
    Configuring the Data Collector
    6m 48s
    FREE ACCESS
  • Locked
    7. 
    Monitoring Resource Usage
    5m 34s
    FREE ACCESS
  • Locked
    8. 
    Utility Control Points
    7m 46s
    FREE ACCESS
  • Locked
    9. 
    Creating a Utility Control Point Part 1
    6m
    FREE ACCESS
  • Locked
    10. 
    Creating a Utility Control Point Part 2
    10m 43s
    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 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

COURSE Azure Serverless Development Principles: Serverless Database & Storage
COURSE Database Fundamentals: Database Concepts
COURSE Azure Data Scientist Associate: Azure Data Storage Monitoring

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Auditing
Likes 57 Likes 57  
COURSE Installation & Configuration
Likes 36 Likes 36  
COURSE Log Shipping & High Availability
Likes 34 Likes 34