As part of this course you are learning below Topics

Here are the following topics related to performance tuning :

-DMV's

-Store Procedures

-DBCC

-Profiler

-Execution Plan

-Database Engine Tuning Advisor

-Activity Monitor

-PerfMon

-EventViewer

-Task Manager

-Indexes

-Statistics

- Waits

- CPU, IO and Memory and long running queries

- Locks & Blockings and Deadlocks

-Temp DB Issues

COURSE INTRODUCTION

This course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and Network Administration

At the end of this course, the student will have extensive knowledge in the following areas:

This course focuses on making SQL Server perform more optimally.

In my first course we laid the groundwork by tuning OUR instances with a top down approach.

WE will continue on that path with this course.

Even though the course has the word “Advanced" in it, there's NOTHING COMPLICATED about taking what's in the course and applying it in the real word.

It's “advanced" in that I'll take more time explaining how to implement these recommendations.

The course is still very much a "buttons and Knobs" course. This simply means WE won't dive too deeply into the minutia. We are still going to focus on items that are easily implemented. Some features will have a level of contention associated with them in the SQL Server community. It will be up to you decide to implement or not.

Additionally, some of the concepts may be new to even more senior level resources so I want to make sure I'll cover the why of the topic as well as the how.

This course will give YOU deeper insight into what it takes to become a skilled PERFORMANCE TUNER. Once thought of as an art, performance tuning is nothing

Take the next step on YOUR performance tuning journey and SIGN UP now.