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 27sUpon 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 52sDuring this video, you will learn how to use Activity Monitor in SQL Server Management Studio to monitor database activity. FREE ACCESS
-
3. Identifying Blocks4m 55sIn this video, learn how to identify blocks using Activity Monitor and stored procedures. FREE ACCESS
-
4. The Data Collector5m 8sUpon completion of this video, you will be able to describe the role of the Data Collector. FREE ACCESS
-
5. Data Collection Design3m 44sUpon completion of this video, you will be able to describe the components that make up the data collection system. FREE ACCESS
-
6. Configuring the Data Collector6m 48sIn this video, you will learn how to configure the Data Collector. FREE ACCESS
-
7. Monitoring Resource Usage5m 34sLearn how to use System Monitor to monitor resource usage. FREE ACCESS
-
8. Utility Control Points7m 46sAfter completing this video, you will be able to describe the purpose of the Utility Control Point and the requirements for its use. FREE ACCESS
-
9. Creating a Utility Control Point Part 16mLearn how to use the Create UCP Wizard to create a SQL Server Utility Control Point. FREE ACCESS
-
10. Creating a Utility Control Point Part 210m 43sIn 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.
