You cannot escape index fragmentation in any SQL Server environment, no matter which version of SQL Server you're using or what hardware or I/O subsystem you have, and it can be detrimental to performance in many ways. In this comprehensive course, you will learn everything you need to know about index fragmentation, including why it's a problem, how it happens, how to detect it, how to avoid it, and how to remove it. The course is applicable to anyone responsible for SQL Server performance, including developers, DBAs, and architects. All course demos are shown on SQL Server 2014 with references to behaviors (where different) on all versions. Strategies for index fragmentation prevention, mitigation, and removal that you will learn in the course apply to SQL Server 2005 onward.
Overview
You cannot escape index fragmentation in any SQL Server environment, no matter which version of SQL Server you're using or what hardware or I/O subsystem you have, and it can be detrimental to performance in many ways. In this comprehensive course, you will learn everything you need to know about index fragmentation, including why it's a problem, how it happens, how to detect it, how to avoid it, and how to remove it. The course is applicable to anyone responsible for SQL Server performance, including developers, DBAs, and architects. All course demos are shown on SQL Server 2014 with references to behaviors (where different) on all versions. Strategies for index fragmentation prevention, mitigation, and removal that you will learn in the course apply to SQL Server 2005 onward.
Syllabus
- Course Overview 1min
- Introduction 8mins
- Index Structure and Index Uses 22mins
- Types of Index Fragmentation 23mins
- Causes of Index Fragmentation 22mins
- Detecting Index Fragmentation 25mins
- Avoiding Index Fragmentation 17mins
- Removing Index Fragmentation 35mins
Taught by
Paul Randal
