Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-465): Tuning Database Performance

Discuss factors that could potentially impact performance, how you can use indexes to improve performance, and how to use query plans generated by SQL Server.

Description

You need to consider more than just the speed of your software when determining the quality of your database performance. In this course, we discuss factors that could potentially impact performance, how you can use indexes to improve performance, how to use query plans generated by SQL Server, and how to monitor the performance of SQL Server. Then, after you know what to look for while monitoring your data storage, we cover how you can baseline the performance metrics and decide how to address any performance problems.
 

Topics Covered Include:
-Tuning Database Performance
-Optimization Using Indexes
-Optimization Using Query Plans
-Performance Monitoring

Full details

Curriculum

  • Course Overview
    Course Orientation
    1:54
    Tuning Database Performance: 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): Tuning Database Performance"" Course.
  • Tuning Database Performance
    Introduction
    1:36
    Tuning Database Performance
    2:52
    Knowledge Check
    0:36
  • Optimization Using Indexes
    Indexes
    4:36
    Index Types
    3:10
    Improving Index Performance
    3:04
    Index Statistics
    1:44
    SHOW ME Demonstration: Assessing Selectivity Column Order
    2:12
    Indexing Strategy
    4:29
    Index Pages
    4:05
    SHOW ME Demonstration: Assessing Index Performance
    2:59
    Knowledge Check
    0:33
  • Optimization Using Query Plans
    Query Plans
    3:45
    Viewing Query Plans
    1:45
    Plan Guides
    2:16
    Knowledge Check
    0:28
  • Performance Monitoring
    Performance Monitoring
    2:08
    Database Engine Tuning Advisor
    0:38
    SHOW ME Demonstration: Database Engine Tuning Advisor (DTA)
    1:41
    SQL Server Profiler
    0:40
    SHOW ME Demonstration: SQL Server Profiler
    2:12
    Performance Monitor
    0:30
    SHOW ME Demonstration: Using Performance Monitor
    2:44
    Activity Monitor
    0:27
    SHOW ME Demonstration: Using Activity Monitor
    2:06
    Performance Baselining and Counters
    3:11
    Knowledge Check
    0:27
    Conclusion
    1:57

Skills

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

Similar Courses

More Courses by this Instructor