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
-
1.Activity Monitor5m 27sUP NEXT
-
2.Using Activity Monitor in SSMS5m 52s
-
3.Identifying Blocks4m 55s
-
4.The Data Collector5m 8s
-
5.Data Collection Design3m 44s
-
6.Configuring the Data Collector6m 48s
-
7.Monitoring Resource Usage5m 34s
-
8.Utility Control Points7m 46s
-
9.Creating a Utility Control Point Part 16m
-
10.Creating a Utility Control Point Part 210m 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.
