Seminar - SQL Server Fragmentation
ON DEMAND WEBCAST: Fragmentation: Fact & Fiction10/17/2007
Fragmentation: an often used word that is unfortunately also so often misunderstood. Fragmentation exists in multiple flavors, has different characteristics and effects on different types of data structures, and can be a major problem in some scenarios (also can be a non-issue at times as well). We'll discuss the different types of index structures, how and when they become fragmented (if they become fragmented), and when you should be concerned about fragmentation (and when not to be so concerned). We'll also be discussing multiple methods for monitoring and analyzing fragmentation, and discussing the different methods for removing fragmentation if appropriate. View this webcast to learn more about fragmentation, including the types of fragmentation, the impact of fragmentation on SQL Server, and how you can best eliminate fragmentation as a performance factor. | In this webcast we’ll discuss: | | - Index structures
- Rebuilds vs. defrags
- Fragmentation what it is and how it happens
- Showcontig vs. index usages DMV
| - Clustered vs. non-clustered indexes
- Heap tables
- System pages for maintaining indexes
- Fragmentation issues = wasted space & poor performance
| You’ll also see a demonstration of Idera’s SQL defrag manager, a product that will automate the process of defragmentation. Speaker: Chad Boyd
|
