Policy-based Management & Performance Monitoring

SQL 2016    |    Intermediate
  • 8 Videos | 58m 48s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
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

  • Playable
    1. 
    Policy-Based Management
    7m 2s
    UP NEXT
  • Playable
    2. 
    Configuring Policy-Based Management Properties
    6m 21s
  • Locked
    3. 
    Creating a Policy-Based Management Policy
    8m 18s
  • Locked
    4. 
    Policy Management
    9m 27s
  • Locked
    5. 
    Identifying Available Space on Data Volumes
    6m 40s
  • Locked
    6. 
    Performance Baselines
    5m
  • Locked
    7. 
    Isolating Performance and Bottleneck Issues
    6m 43s
  • Locked
    8. 
    Exercise: Monitoring Instances in SQL Server 2016
    5m 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.

YOU MIGHT ALSO LIKE

Likes 26 Likes 26  
Likes 40 Likes 40  
Likes 34 Likes 34  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 110 Likes 110  
Likes 37 Likes 37  
COURSE T-SQL Queries
Likes 173 Likes 173