Policy-based Management & Performance Monitoring

SQL 2016    |    Intermediate
  • 8 videos | 55m 18s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)
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 2s
    Upon completion of this video, you will be able to describe the purpose and components of Policy-Based Management. FREE ACCESS
  • 6m 21s
    In this video, you will learn how to configure Policy-Based Management properties and failure notification alerts. FREE ACCESS
  • Locked
    3.  Creating a Policy-Based Management Policy
    8m 18s
    In this video, you will learn how to create a Policy-Based Management policy using SQL Server Management Studio. FREE ACCESS
  • Locked
    4.  Policy Management
    9m 27s
    Upon completion of this video, you will be able to recognize how to manage an existing Policy-Based Management policy. FREE ACCESS
  • Locked
    5.  Identifying Available Space on Data Volumes
    6m 40s
    Find out how to identify used and available space on data volumes. FREE ACCESS
  • Locked
    6.  Performance Baselines
    5m
    After completing this video, you will be able to recognize what affects the performance of a server and when to use baseline measurements. FREE ACCESS
  • Locked
    7.  Isolating Performance and Bottleneck Issues
    6m 43s
    After completing this video, you will be able to recognize performance issues that may affect SQL Server. FREE ACCESS
  • Locked
    8.  Exercise: Monitoring Instances in SQL Server 2016
    5m 50s
    In 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.

YOU MIGHT ALSO LIKE

Course Managing Modern Desktops: Compliance Policies & Configuration Profiles
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)
Channel Auditing
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Sets & Predicate Logic
Rating 4.8 of 22 users Rating 4.8 of 22 users (22)
Course Index & Statistical Management
Rating 4.4 of 18 users Rating 4.4 of 18 users (18)