Policy-based Management & Performance Monitoring
SQL 2016
| Intermediate
- 8 Videos | 55m 18s
- Includes Assessment
- Earns a Badge
Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore Policy-Based Management and performance monitoring of SQL Server 2016 instances.
WHAT YOU WILL LEARN
-
describe the purpose and components of Policy-Based Management
configure Policy-Based Management properties and failure notification alerts
create a Policy-Based Management policy using SQL Server Management Studio
recognize how to manage an existing Policy-Based Management policy -
identify used and available space on data volumes
recognize what affects the performance of a server and when to use baseline measurements
recognize performance issues that may affect SQL Server
monitor instances in SQL Server 2016
IN THIS COURSE
-
1.Policy-Based Management7m 2sUP NEXT
-
2.Configuring Policy-Based Management Properties6m 21s
-
3.Creating a Policy-Based Management Policy8m 18s
-
4.Policy Management9m 27s
-
5.Identifying Available Space on Data Volumes6m 40s
-
6.Performance Baselines5m
-
7.Isolating Performance and Bottleneck Issues6m 43s
-
8.Exercise: Monitoring Instances in SQL Server 20165m 50s
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.
