Monitoring Database Activity

SQL 2016    |    Intermediate
  • 10 videos | 1h 1m 57s
  • Includes Assessment
  • Earns a Badge
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

  • 5m 27s
    Upon completion of this video, you will be able to recognize the types of activities that can be monitored using the Activity Monitor. FREE ACCESS
  • 5m 52s
    During this video, you will learn how to use Activity Monitor in SQL Server Management Studio to monitor database activity. FREE ACCESS
  • Locked
    3.  Identifying Blocks
    4m 55s
    In this video, learn how to identify blocks using Activity Monitor and stored procedures. FREE ACCESS
  • Locked
    4.  The Data Collector
    5m 8s
    Upon completion of this video, you will be able to describe the role of the Data Collector. FREE ACCESS
  • Locked
    5.  Data Collection Design
    3m 44s
    Upon completion of this video, you will be able to describe the components that make up the data collection system. FREE ACCESS
  • Locked
    6.  Configuring the Data Collector
    6m 48s
    In this video, you will learn how to configure the Data Collector. FREE ACCESS
  • Locked
    7.  Monitoring Resource Usage
    5m 34s
    Learn how to use System Monitor to monitor resource usage. FREE ACCESS
  • Locked
    8.  Utility Control Points
    7m 46s
    After completing this video, you will be able to describe the purpose of the Utility Control Point and the requirements for its use. FREE ACCESS
  • Locked
    9.  Creating a Utility Control Point Part 1
    6m
    Learn how to use the Create UCP Wizard to create a SQL Server Utility Control Point. FREE ACCESS
  • Locked
    10.  Creating a Utility Control Point Part 2
    10m 43s
    In this video, you will learn how to create a SQL Server Utility Control Point. 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

Course Data Engineering on Microsoft Azure: Synapse Analytics
Course Microsoft Azure Fundamentals: Azure Storage
Book Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Index & Statistical Management
Course Database Restoration
Course Policy-based Management & Performance Monitoring