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
-
7m 2sUpon completion of this video, you will be able to describe the purpose and components of Policy-Based Management. FREE ACCESS
-
6m 21sIn this video, you will learn how to configure Policy-Based Management properties and failure notification alerts. FREE ACCESS
-
3. Creating a Policy-Based Management Policy8m 18sIn this video, you will learn how to create a Policy-Based Management policy using SQL Server Management Studio. FREE ACCESS
-
4. Policy Management9m 27sUpon completion of this video, you will be able to recognize how to manage an existing Policy-Based Management policy. FREE ACCESS
-
5. Identifying Available Space on Data Volumes6m 40sFind out how to identify used and available space on data volumes. FREE ACCESS
-
6. Performance Baselines5mAfter completing this video, you will be able to recognize what affects the performance of a server and when to use baseline measurements. FREE ACCESS
-
7. Isolating Performance and Bottleneck Issues6m 43sAfter completing this video, you will be able to recognize performance issues that may affect SQL Server. FREE ACCESS
-
8. Exercise: Monitoring Instances in SQL Server 20165m 50sIn this video, you will learn how to monitor instances in SQL Server 2016. 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.
