Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Performance Tuning Part 1
Rating: 4.5 out of 5(5,872 ratings)
24,541 students
Created byRaphael Asghar
Last updated 3/2020
English

What you'll learn

  • At the end of this course, the student will have extensive knowledge in the following areas: Types of indexes that can affect performance, ability to read and understand the execution plans, determine the causes of wait stats, views deeply into statistics, comprehend the cause of the fill factor and page splits, view various execution modes and much much more

Course content

1 section • 37 lectures • 5h 57m total length

  • DOWNLOAD APPLICATIONS8:32
  • SQL Performance Tuning Part 113:02
  • CREATE A VIRTUAL MACHINE17:11
  • CONFIGURING WINDOWS SERVER8:02
  • INSTALLING SQL SERVER 2016 PART 19:45
  • INSTALLING SQL SERVER 2016 PART 210:15
  • INSTALLING SSMS2:05
  • RESTORING DATABASE6:34
  • WHAT IS SQL PERFORMANCE TUNING10:38
  • HARDWARE9:30
  • DETAIL KNOWLEDGE OF PARTS5:24
  • AUTOGROWTH SETTING AND QUIZ 19:32
  • INDEXES4:39
  • WHAT IS INDEXING15:46
  • CREATE A CLUSTERED INDEX WITH PK4:47
  • NON CLUSTERED INDEX9:58
  • B TREE5:27
  • B TREE NON CLUSTER INDEX4:11
  • ANATOMY OF SQL PAGE5:21
  • CAUSING A PAGE SPLIT18:18
  • TYPES OF INDEXES3:50
  • WHAT IS THE QUERY OPTIMIZER11:05
  • OPERATORS7:16
  • TABLE SCAN17:17
  • NON CLUSTERED INDEX PART 1 AND QUIZ 212:00
  • NON CLUSTERED INDEX PART 211:56
  • ORDER OF COLUMN IN NON CLUSTERED INDEX3:14
  • FILTER NON CLUSTERED INDEX9:11
  • SORT OPERATOR4:07
  • JOIN OPERATORS12:21
  • STATISTICS19:05
  • What is Locking?11:26
  • What is blocking?9:57
  • DEADLOCKS8:27
  • WAIT STATISTICS14:37
  • RECOMPILATIONS7:08

    Explore how the query optimizer compiles a stored procedure by parsing, validating, and generating an execution plan, then caching it for fast reuse. Understand recompilation and how parameterization mitigates it.

  • TEMPDB AND QUIZ 315:34

Requirements

  • You should have a good understanding of SQL Server Administration. I would highly recommend the following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3

Description

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:

Indexes, wait stats, fill factor, fragmentation, data and log file allocation, tempdb configuration, common performance issues, blocking, locking, database tuning advisor, execution plan, caching, virtualization and much more

You should have a good understanding of SQL Server Administration.  I would highly recommend the following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3

Who this course is for:

  • 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

Report abuse