SQL Server 2005 - Understanding ouput of DBCC SHOWCONTIG
- by user169743
I'm seeing some slow performance on a SQL Server 2005 database. I've been doing some research regarding SQL Server performance but I'm having difficulty fully understanding the output of SHOWCONTIG and would be very grateful if someone could have a look and offer some suggestions to improve performance.
TABLE level scan performed.
Pages Scanned................................: 19348
Extents Scanned..............................: 2427
Extent Switches..............................: 3829
Avg. Pages per Extent........................: 8.0
Scan Density [Best Count:Actual Count].......: 63.16% [2419:3830]
Logical Scan Fragmentation ..................: 8.40%
Extent Scan Fragmentation ...................: 35.15%
Avg. Bytes Free per Page.....................: 938.1
Avg. Page Density (full).....................: 88.41%