SQL Server Performance Tuning Part 1
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
- Preview08:32
- Preview13:02
- 17:11CREATE A VIRTUAL MACHINE
- 08:02CONFIGURING WINDOWS SERVER
- 09:45INSTALLING SQL SERVER 2016 PART 1
- 10:15INSTALLING SQL SERVER 2016 PART 2
- 02:05INSTALLING SSMS
- 06:34RESTORING DATABASE
- 10:38WHAT IS SQL PERFORMANCE TUNING
- 09:30HARDWARE
- 05:24DETAIL KNOWLEDGE OF PARTS
- 09:32AUTOGROWTH SETTING AND QUIZ 1
- 04:39INDEXES
- 15:46WHAT IS INDEXING
- 04:47CREATE A CLUSTERED INDEX WITH PK
- 09:58NON CLUSTERED INDEX
- 05:27B TREE
- 04:11B TREE NON CLUSTER INDEX
- 05:21ANATOMY OF SQL PAGE
- 18:18CAUSING A PAGE SPLIT
- 03:50TYPES OF INDEXES
- 11:05WHAT IS THE QUERY OPTIMIZER
- 07:16OPERATORS
- 17:17TABLE SCAN
- 12:00NON CLUSTERED INDEX PART 1 AND QUIZ 2
- 11:56NON CLUSTERED INDEX PART 2
- 03:14ORDER OF COLUMN IN NON CLUSTERED INDEX
- 09:11FILTER NON CLUSTERED INDEX
- 04:07SORT OPERATOR
- 12:21JOIN OPERATORS
- 19:05STATISTICS
- 11:26What is Locking?
- 09:57What is blocking?
- 08:27DEADLOCKS
- 14:37WAIT STATISTICS
- 07:08RECOMPILATIONS
- 15:34TEMPDB AND QUIZ 3
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
Instructor
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.