SQL Server Performance Tuning Part 1




SQL Server Performance Tuning Part 1

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

Detail building blocks of SQL performance tuning

Url: View Details

What you will 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

Rating: 4.42878

Level: Beginner Level

Duration: 6 hours

Instructor: Raphael Asghar


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap