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 Monitoruse Activity Monitor in SQL Server Management Studio to monitor database activityidentify blocks using Activity Monitor and stored proceduresdescribe the role of the Data Collectordescribe the components that make up the data collection system
-
configure the Data Collectoruse System Monitor to monitor resource usagedescribe the purpose of Utility Control Point and the requirements for its useuse the Create UCP Wizard to create a SQL Server Utility Control Pointcomplete 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.