Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Performance Tuning Practically in SQL Server
Rating: 4.3 out of 5(33 ratings)
332 students

Learn Performance Tuning Practically in SQL Server

Become expert in Performance Tuning
Created byRajasekhar Reddy Bolla
Last updated 8/2021
English
English [Auto],

What you'll learn

  • If you have basic understanding of SQL Server and want to learn how to tune and optimize a SQL Server then this course is for you.
  • his course is not a beginner’s course. Most of the students will be mid-level to senior SQL Server resources.
  • You can improve your SQL Server performance by 80%. You can resolve CPU and Memory and IO pressures
  • You will learn how fast you can resolve the issues like blocking and deadlocks.

Course content

1 section • 7 lectures • 8h 38m total length

  • Day 12:08:00

    Learn practical sql server performance tuning through database and disk level settings, index maintenance, missing and duplicate indexes, file groups, and proactive maintenance strategies.

  • Day 236:21

    Explore practical SQL Server performance tuning through weekly maintenance, setting database level options, monitoring fragmentation, backups, and memory and buffer considerations to optimize queries and reliability.

  • Day 337:38

    Learn to optimize SQL Server queries by using estimated and actual execution plans, identifying missing indexes, and implementing cluster and non-cluster indexes to dramatically reduce query cost.

  • Day 436:40

    Day 4 covers practical performance tuning in SQL Server, guiding you through analyzing execution plans, identifying slow queries, and optimizing with indexes and included columns.

  • Day 535:26

    Learn practical SQL Server performance tuning by viewing execution plans, comparing estimated versus actual plans, and monitoring current queries and blocking to optimize CPU, memory, and disk usage.

  • Day 61:28:16

    Explore practical sql server performance tuning by analyzing execution plans, profiling queries with templates, and optimizing ad hoc plans, with hands-on discussion of automation, backups, and reports.

  • Day 72:35:52

    Explore practical SQL Server performance tuning by analyzing memory usage, monitoring queries, and resolving blocking and deadlocks. Learn to optimize indexes, manage backups, and monitor through DMVs and WMI tools.

Requirements

  • You will need to have SQL Server 2005 or 2008 or 2012 or 2014 or any higher version installed. It can be an express version.

Description

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.


Who this course is for:

  • If you have basic understanding of SQL Server and want to learn how to tune and optimize a SQL Server then this course is for you.

Report abuse