Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-465): Monitoring Server Health

We cover several measures and policies which are used to improve the performance of SQL Server and how the impact changes have to the SQL Server.

Description

This course discusses how to best monitor the performance of SQL Server. We cover several measures and policies which are used to improve the performance of SQL Server. We also discuss how the impact changes have to the SQL Server as well as how you may address the performance issues identified.
 

Topics Covered Include:
-Monitoring Server Health
-SQL Server Utility

Full details

Curriculum

  • Course Overview
    Course Orientation
    1:54
    Monitoring Server Health: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-465): Monitoring Server Health"" Course."
  • Monitor Server Health
    Introduction
    1:16
    SQL Server Health Monitoring
    2:47
    Challenges to SQL Server Health Monitoring
    2:36
    Options to Monitor Server Health
    2:15
    Data Collector and Management Data Warehouse
    1:04
    Data Collector
    2:58
    Knowledge Check
    0:45
  • SQL Server Utility
    SQL Server Utility
    2:00
    SQL Server Utility Components
    2:48
    SHOW ME Demonstration: Creating Utility Control Point
    2:04
    SHOW ME Demonstration: Enroll an Instance
    1:40
    Considerations in Creating UCP
    1:31
    SHOW ME Demonstration: Remove the UCP
    0:58
    Health Policies
    4:13
    SHOW ME Demonstration: Configure a Health Policy
    1:05
    Monitoring Server Health
    3:22
    Knowledge Check
    0:35
    Conclusion
    0:55

Skills

  • Database Management System (DBMS)
  • Database Management
  • SQL Server

Similar Courses

More Courses by this Instructor