July 10, 2012 at 7:54 am
Hi everyone.
After some advice , on a SQL 2000 server.
DBCC SHOWCONTIG scanning 'xxxx' table...
Table: 'xxxx' (562101043); index ID: 0, database ID: 17
TABLE level scan performed.
- Pages Scanned................................: 7175
- Extents Scanned..............................: 899
- Extent Switches..............................: 898
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.78% [897:899]
- Extent Scan Fragmentation ...................: 25.58%
- Avg. Bytes Free per Page.....................: 274.4
- Avg. Page Density (full).....................: 96.61%
Running dbcc dbreindex ('xxxx') does not improve the Extent Scan fragmentation.
What else could I look at ??
Cheers for any advice.
July 10, 2012 at 8:04 am
MickyD (7/10/2012)
Hi everyone.After some advice , on a SQL 2000 server.
DBCC SHOWCONTIG scanning 'xxxx' table...
Table: 'xxxx' (562101043); index ID: 0, database ID: 17
TABLE level scan performed.
- Pages Scanned................................: 7175
- Extents Scanned..............................: 899
- Extent Switches..............................: 898
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.78% [897:899]
- Extent Scan Fragmentation ...................: 25.58%
- Avg. Bytes Free per Page.....................: 274.4
- Avg. Page Density (full).....................: 96.61%
Running dbcc dbreindex ('xxxx') does not improve the Extent Scan fragmentation.
What else could I look at ??
Cheers for any advice.
This is a heap.
July 10, 2012 at 8:06 am
The table is a heap (index id=0), which means it does not have a clustered index.
You cannot do a reindex rebuild of a heap table in SQL Server 2000.
To be able to reindex, you should create a clustered index on the table.
July 10, 2012 at 8:36 am
Thanks everyone , understood.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply