Fixing my table based on Dbcc Showcontig results

[SR]

Can someone please help me interpret this result set below and suggest
on way I can speed up my table? What changes should I make?

DBCC SHOWCONTIG scanning 'tblListing' table...
Table: 'tblListing' (1092914965); index ID: 1, database ID: 13
TABLE level scan performed.
- Pages Scanned................................: 97044
- Extents Scanned..............................: 12177
- Extent Switches..............................: 13452
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 90.17% [12131:13453]
- Logical Scan Fragmentation ..................: 0.86%
- Extent Scan Fragmentation ...................: 2.68%
- Avg. Bytes Free per Page.....................: 1415.8
- Avg. Page Density (full).....................: 82.51%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Thank you.

[Ryan Stonecipher [MSFT]]

You should take a look at ttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx. Let us know if you have any questions after reading this. Keep in mind that it's quite possible that given your server workload, index defragmentation isn't at all necessary.

Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"SR" <yo****@socal.rr.com> wrote in message news:ba**************************@posting.google.c om...
Can someone please help me interpret this result set below and suggest
on way I can speed up my table? What changes should I make?

DBCC SHOWCONTIG scanning 'tblListing' table...
Table: 'tblListing' (1092914965); index ID: 1, database ID: 13
TABLE level scan performed.
- Pages Scanned................................: 97044
- Extents Scanned..............................: 12177
- Extent Switches..............................: 13452
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 90.17% [12131:13453]
- Logical Scan Fragmentation ..................: 0.86%
- Extent Scan Fragmentation ...................: 2.68%
- Avg. Bytes Free per Page.....................: 1415.8
- Avg. Page Density (full).....................: 82.51%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Thank you.

[Simon Hayes]

"SR" <yo****@socal.rr.com> wrote in message
news:ba**************************@posting.google.c om...

Can someone please help me interpret this result set below and suggest
on way I can speed up my table? What changes should I make?

DBCC SHOWCONTIG scanning 'tblListing' table...
Table: 'tblListing' (1092914965); index ID: 1, database ID: 13
TABLE level scan performed.
- Pages Scanned................................: 97044
- Extents Scanned..............................: 12177
- Extent Switches..............................: 13452
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 90.17% [12131:13453]
- Logical Scan Fragmentation ..................: 0.86%
- Extent Scan Fragmentation ...................: 2.68%
- Avg. Bytes Free per Page.....................: 1415.8
- Avg. Page Density (full).....................: 82.51%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Thank you.

http://www.sql-server-performance.co...showcontig.asp

At first glance, the output seems fine - there is very little fragmentation,
and the scan density is high. If you're having performance issues with this
table, you may want to give some more information. In particular, the CREATE
TABLE and CREATE INDEX statements, plus a query which is performing badly,
and the reason why you believe this table is the problem (eg. the execution
plan for the query).

Simon