Monitoring Database Activity

SQL 2016    |    Intermediate
  • 10 Videos | 1h 6m 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
  • Locked
    4. 
    The Data Collector
    5m 8s
  • Locked
    5. 
    Data Collection Design
    3m 44s
  • Locked
    6. 
    Configuring the Data Collector
    6m 48s
  • Locked
    7. 
    Monitoring Resource Usage
    5m 34s
  • Locked
    8. 
    Utility Control Points
    7m 46s
  • Locked
    9. 
    Creating a Utility Control Point Part 1
    6m
  • Locked
    10. 
    Creating a Utility Control Point Part 2
    10m 43s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 110 Likes 110  
Likes 37 Likes 37  
Likes 61 Likes 61