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

Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Book Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database, 3rd Edition
Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Managing Database Integrity
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
Course Database Restoration
Rating 4.7 of 60 users Rating 4.7 of 60 users (60)
Course Database Mail & Alerts
Rating 4.1 of 29 users Rating 4.1 of 29 users (29)