Sql Server Performance Tuning Part 1

  1. Home
  2. Sql-server
  3. Sql Server Performance Tuning Part 1

Tags: SQL Server

Detail building blocks of SQL performance tuning

Last updated 2022-01-10 | 4.5

- 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

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

* 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

Course content

1 sections • 37 lectures

SQL Server Performance Tuning Part 1 of 2 37 lectures

DOWNLOAD APPLICATIONS Preview 08:32

SQL Performance Tuning Part 1 Preview 13:02

CREATE A VIRTUAL MACHINE Preview 17:11

CONFIGURING WINDOWS SERVER Preview 08:02

INSTALLING SQL SERVER 2016 PART 1 Preview 09:45

INSTALLING SQL SERVER 2016 PART 2 Preview 10:15

INSTALLING SSMS Preview 02:05

RESTORING DATABASE Preview 06:34

WHAT IS SQL PERFORMANCE TUNING Preview 10:38

HARDWARE Preview 09:30

DETAIL KNOWLEDGE OF PARTS Preview 05:24

AUTOGROWTH SETTING AND QUIZ 1 Preview 09:32

INDEXES Preview 04:39

WHAT IS INDEXING Preview 15:46

CREATE A CLUSTERED INDEX WITH PK Preview 04:47

NON CLUSTERED INDEX Preview 09:58

B TREE Preview 05:27

B TREE NON CLUSTER INDEX Preview 04:11

ANATOMY OF SQL PAGE Preview 05:21

CAUSING A PAGE SPLIT Preview 18:18

TYPES OF INDEXES Preview 03:50

WHAT IS THE QUERY OPTIMIZER Preview 11:05

OPERATORS Preview 07:16

TABLE SCAN Preview 17:17

NON CLUSTERED INDEX PART 1 AND QUIZ 2 Preview 12:00

NON CLUSTERED INDEX PART 2 Preview 11:56

ORDER OF COLUMN IN NON CLUSTERED INDEX Preview 03:14

FILTER NON CLUSTERED INDEX Preview 09:11

SORT OPERATOR Preview 04:07

JOIN OPERATORS Preview 12:21

STATISTICS Preview 19:05

What is Locking? Preview 11:26

What is blocking? Preview 09:57

DEADLOCKS Preview 08:27

WAIT STATISTICS Preview 14:37

RECOMPILATIONS Preview 07:08

TEMPDB AND QUIZ 3 Preview 15:34