SQL Server Performance

how often to Re Index

Discussion in 'Performance Tuning for DBAs' started by spiralstairs99, Aug 14, 2003.

  1. spiralstairs99 New Member

    I have a 12 tables that we've historized. every night we drop the last 2 weeks worth of data and pull new data over from an old D-Isam database. I would say the % of records dropped and brough over on each table does not exceed 8% and probably averages about 4%.
    when this data is entered into my table does the current indexing index this data or do i need to reindex everyday?
    Currently i reindex everyday, but due to increased activity, etc. resources are becoming an issue and i'm looking to scale back on some activity wherever i can and the current indexing takes almost 2 hours each time.
    Another note about this is the data is deleted and inserted through a VB app and not DTS.

    and input would be appreciated.

    thanks

    spiral
  2. gaurav_bindlish New Member

    Depends on the indexes present on the table. If you are inserting data from the middle pages, the fragmentation can be high and may become a point of concern. I would say, check the fragementation of the index and then decide if you want to reindex the table.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. satya Moderator

    You can run DBCC INDEXDEFRAG which could help some extent and enable re-indexing every week.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. bambola New Member

    You can decide to rebuild indexes according to the ScanDensity. You can get the the value from running DBCC SHOWCONTIG WITH TABLERESULTS.

    Bambola.
  5. ykchakri New Member

    The 'Scandensity' and 'Extent scan fragmentation' values of the DBCC SHOWCONTIG command can help you decide when to re-build the index. For a fully re-built index, the scandensity will be close to 100% and the 'Extent scan fragmentation' will be close to 0%.
    In my case, I've created a small procedure that runs once a week and checks these values on every index and runs 'DBCC INDEXDEFRAG' on those indexes that are having these values beyond certain pre-defined limits.
  6. Argyle New Member

    Look up DBCC SHOWCONTIG in BOL and there will be an example script on how to use it to run reindex based on the values it returns.

    /Argyle
  7. vbkenya New Member

    ykchakri, would you mind sharing "the small procedure" you created with the rest of the team?

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  8. ykchakri New Member

    Here is it. Sorry!, it's not nicely formatted. But, who cares, it works <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />CREATE proc spa_indexdefrag @tblname varchar(255) = '', @dbname varchar(50) = NULL as<br /><br />If @dbname is NULL <br />set @dbname = db_name()<br /><br />exec ('Alter database '+@dbname+<br />' set RECOVERY BULK_LOGGED')<br /><br />if not exists (select * from Admin..sysobjects where name = 'tbl_ContigInfo')<br />begin<br />create table Admin..tbl_ContigInfo ([db_name] nvarchar(50) not null, [tbl_name] nvarchar(255) not null,[tbl_id] int, <br />[Ind_name] nvarchar(255) not null, [ind_id] int, [pages] int, [row_count] int,[Min_RecordSize] int,[Max_RecordSize] int,<br /> [Avg_RecordSize] int, [Extents] int, [ExtentSwitches] int, [av_FreeBytes] float(2), [av_PageDensity] float(2),<br />[ScanDensity] float(2), [BestCount] int, [ActualCount] int, [Logical_frag] float(2), [Extent_frag] float(2),<br />[StatsDate] DATETIME, [dt_monitor] DATETIME default getdate() not null)<br /><br />ALTER TABLE Admin..tbl_ContigInfo WITH NOCHECK ADD <br />CONSTRAINT [PK_ContigInfo] PRIMARY KEY CLUSTERED <br />([db_name],<br />[tbl_name],<br />[Ind_name],<br />[DT_monitor]<br />) ON [PRIMARY] <br />end<br /><br />create table #contiginfo (ObjectName nvarchar(255), ObjectId int,IndexName nvarchar(255),IndexId int ,Level int ,Pages int ,<br />Rows int ,MinimumRecordSize int ,MaximumRecordSize int ,AverageRecordSize int ,ForwardedRecords int ,Extents int ,<br />ExtentSwitches int ,AverageFreeBytes Float(2) ,AveragePageDensity Float(2),ScanDensity Float(2),BestCount int ,<br />ActualCount int ,<br />LogicalFragmentation Float(2) ,ExtentFragmentation Float(2))<br /><br />--select the table name into a temp table, if table name is not passed then all the user tables<br /> select convert(varchar(255),a.name) as tablename into #sdt<br /> from dbo.sysobjects a <br /> where a.type='u' and (a.name = @tblname or @tblname = '')<br /><br />declare @x varchar(255), @y varchar(255)<br />--cursor for each table<br />declare cOne cursor for select distinct tablename from #sdt order by tablename<br />open cOne<br />fetch next from cOne into @x<br /><br />While @@fetch_status=0<br /> begin<br /> set @y = 'DBCC SHOWCONTIG (''' + @x + ''')<br /> WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS'<br /><br /> insert into #contiginfo exec(@y)<br /><br />SELECT 'Table_Name' = o.name, 'Index_Name' = i.name, <br /> 'StatsDate' = STATS_DATE(i.id, i.indid)<br />into #statsdate<br />FROM sysobjects o, sysindexes i<br />WHERE o.id = i.id AND i.indid &lt;&gt; 255 AND o.name = @x<br /><br />Insert into Admin..tbl_ContigInfo ([db_name], tbl_name, tbl_id, Ind_name, ind_id ,<br /> pages, row_count,Min_RecordSize,Max_RecordSize,Avg_RecordSize, Extents, <br /> ExtentSwitches, av_FreeBytes, av_PageDensity,ScanDensity,BestCount, ActualCount, <br />Logical_frag, Extent_frag, StatsDate )select @dbname, ObjectName,ObjectId,IndexName,IndexId,Pages,Rows,<br />MinimumRecordSize,MaximumRecordSize,AverageRecordSize,Extents,ExtentSwitches,AverageFreeBytes,<br />AveragePageDensity,ScanDensity,BestCount,ActualCount,<br />LogicalFragmentation,ExtentFragmentation, s.StatsDate from #contiginfo c, #statsdate s<br />where c.ObjectName = s.Table_Name and c.IndexName = s.Index_Name<br /><br /><br />declare @objid int, @indid int<br />declare cOntig cursor for select distinct ObjectId, IndexId from #contiginfo <br />where (IndexID &lt;&gt; 0 and IndexID &lt;&gt; 255) and (LogicalFragmentation &gt; 50 or ScanDensity &lt; 50) order by IndexId<br />open cOntig<br />fetch next from cOntig into @objid, @indid<br /><br />While @@fetch_status = 0<br />begin<br />select 'De-fragmenting '+@dbname+ '..'+object_name(@objid)+ ','+cast (@indid as varchar(25)) +' at '+ convert(varchar(20),getdate(),20)<br />DBCC INDEXDEFRAG (0, @objid, @indid) WITH NO_INFOMSGS <br />--If @ind = '' break --if index name is empty then the DBREINDEX will re-index all indexes, so break the loop<br />--If (select indid from sysindexes where name = @ind) = 1 break -- If it is a clustered index, break the loop<br />backup log @dbname with truncate_only<br />fetch next from cOntig into @objid, @indid<br /><br />end<br />close cOntig<br />deallocate cOntig<br /><br />truncate table #contiginfo<br />drop table #statsdate<br />fetch next from cOne into @x<br />end<br />close cOne<br />deallocate cOne<br /><br />exec ('DBCC SHRINKFILE (N'''+@dbname+'_Log'',TRUNCATEONLY)')<br />exec ('Alter database '+@dbname+<br />' set RECOVERY FULL')<br /><br /><br />GO<br />
  9. ykchakri New Member

    And I will be glad if anyone can give me any suggestions to fine tune it.
  10. gaurav_bindlish New Member

    ykchakri, I have deleted 2 duplicate posts of your last post.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  11. gaurav_bindlish New Member

    BTW, there is a similar script at
    http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci841586,00.html

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  12. ykchakri New Member

    quote:Originally posted by gaurav_bindlish

    ykchakri, I have deleted 2 duplicate posts of your last post.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard


    Thank you, Gaurav.
  13. bambola New Member

    I would try to write it without cursors. It's a draft so bare with me.


    declare @scanDencity int
    select @scanDencity = 100 -- or some other default value that is accepted.

    CREATE TABLE #tResults
    (
    row_id int identity (1,1),
    ObjectName CHAR (255),
    ObjectId INT,
    IndexName CHAR (255),
    IndexId INT,
    Lvl INT,
    CountPages INT,
    CountRows INT,
    MinRecSize INT,
    MaxRecSize INT,
    AvgRecSize INT,
    ForRecCount INT,
    Extents INT,
    ExtentSwitches INT,
    AvgFreeBytes INT,
    AvgPageDensity INT,
    ScanDensity DECIMAL,
    BestCount INT,
    ActualCount INT,
    LogicalFrag DECIMAL,
    ExtentFrag DECIMAL
    )

    INSERT INTO #tResults
    EXEC('DBCC SHOWCONTIG WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS')

    DELETE
    FROM #tResults
    WHERE ObjectID NOT IN
    (
    SELECT o.id FROM sysobjects o, sysindexes i
    where o.id = i.id
    and OBJECTPROPERTY(OBJECT_ID(o.name),N'IsUserTable') = 1
    and objectproperty(o.id,'ismsshipped') = 0
    )
    OR ScanDensity > @scanDencity
    -- or whatever you want to exclude. if one insists on using a cursor than at lease
    -- result set would be smaller

    WHILE...
    BEGIN
    -- While loop over the rest of the table, using the Identity field in the
    -- table with whatever needs to be done.
    END

    DROP TABLE #tResults
    Bambola.
  14. thomas New Member

    I posted a similar one a while ago in the Scripts section on here.

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=444

    It does conditional de-fragging using dbcc dbreindex() - you pass it the level of scan density below which you want to reindex .. and it does the biz. It does use cursors, but hey, they're in the product, so use 'em. I can run this on a 55GB live Peoplesoft database every night and it takes 45 mins on a 8-way box.



    Tom Pullen
    DBA, Oxfam GB
  15. bambola New Member

    It was actually from you that I learned to use SHOWCONTIG with ScanDensity to <br />deciede which indexes to rebuild! Thanks Tom <img src='/community/emoticons/emotion-1.gif' alt=':)' /> <br /><br />Bambola.
  16. thomas New Member

    hey, glad to hear i've been of some help!

    i think it's easy to get over-worried about cursors. For this kind of cycling adminstrative task they are perfect - i believe that cursors are only dangerous when programmers start putting SQL in them which itself is inefficient.

    Set-based operations are preferable generally but for this kind of thing cursors are easy and it's what they are there for.



    Tom Pullen
    DBA, Oxfam GB
  17. Argyle New Member

    Here is a similar script I use for SQL 2000 that does either dbreindex or indexdefrag. Created by Bill Wunder but his page seems to be down now <a target="_blank" href=http://home.attbi.com/~bwunder/>http://home.attbi.com/~bwunder/</a>).<br /><pre><br />CREATE procedure dbo.IndexMaintenanceForDB<br />@pDatabaseName varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br />as<br />/*******************************************************************************************************<br />*admin.dbo.indexMaintenanceForDB<br />*Bill Wunder<br />*Identify which indexes need to be maintained and which maintenance operation to<br />* use. If the scan density is less than 90% maintain the index. If the index has<br />*over 10000 paged defrag it otherwise reindex it. If a table has a clustered index<br />* that will be maintained by a reindex do not maintain other indexes because they<br />* will be rebuilt when the clustered index is reindexed. Keep all fragmentation <br />* history for further analysis.<br />*<br />* Statistic Description <br />* Pages ScannedNumber of pages in the table or index. <br />* Extents Scanned Number of extents in the table or index. <br />* Extent Switches Number of times the DBCC statement moved from one extent to another <br />*while it traversed the pages of the table or index. <br />* Avg. Pages per Extent Number of pages per extent in the page chain. <br />* Scan Density [Best Count: Actual Count] Best count is the ideal number of extent <br />*changes if everything is contiguously linked. Actual count is the actual <br />*number of extent changes. The number in scan density is 100 if everything <br />*is contiguous; if it is less than 100, some fragmentation exists. Scan <br />*density is a percentage. <br />* Logical Scan Fragmentation Percentage of out-of-order pages returned from scanning the leaf pages of <br />*an index. This number is not relevant to heaps and text indexes. An out of <br />*order page is one for which the next page indicated in an IAM is a <br />*different page than the page pointed to by the next page pointer in the <br />*leaf page. <br />* Extent Scan Fragmentation Percentage of out-of-order extents in scanning the leaf pages of an index. <br />*This number is not relevant to heaps. An out-of-order extent is one for <br />*which the extent containing the current page for an index is not physically <br />*the next extent after the extent containing the previous page for an index. <br />* Avg. Bytes free per page Average number of free bytes on the pages scanned. The higher the number, <br />*the less full the pages are. Lower numbers are better. This number is also <br />*affected by row size; a large row size can result in a higher number. <br />* Avg. Page density (full) Average page density (as a percentage). This value takes into account row <br />*size, so it is a more accurate indication of how full your pages are. The <br />*higher the percentage, the better. <br />*<br />* status <br />*0 - under consideration<br />*1 - defrag<br />*2 - defrag in progress<br />*3 - defrag complete<br />*4 - reindex<br />*5 - reindex in progress<br />*6 - reindex complete<br />*9 - eliminated from consideration<br />* 10 - 19 - historical <br />*<br />* Updates:<br />* 030613 - Magnus Andersson: Updated to handle object names with spaces, use update statistics after defrag and save start and end time.<br />********************************************************************************************************/<br />IF @pDatabaseName IN ('master','tempDB')<br />BEGIN<br />RETURN<br />END<br /><br />declare @sqlstr nvarchar(4000),<br />@sqlstrStats nvarchar(4000),<br />@ObjectOwner varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' />, <br />@ObjectName varchar(255),<br />@IndexName varchar(255),<br />@status int<br /><br />if object_id('admin.dbo.fraglist','U') is null<br />CREATE TABLE admin.dbo.fraglist (<br /> DatabaseName varchar (12<img src='/community/emoticons/emotion-11.gif' alt='8)' />,<br /> ObjectOwner varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' />,<br /> ObjectName varchar (255),<br /> ObjectId int,<br /> IndexName varchar(255),<br /> IndexId int,<br /> Lvl int,<br /> CountPages int,<br /> CountRows int,<br /> MinRecSize int,<br /> MaxRecSize int,<br /> AvgRecSize int,<br /> ForRecCount int,<br /> Extents int,<br /> ExtentSwitches int,<br /> AvgFreeBytes int,<br /> AvgPageDensity int,<br /> ScanDensity decimal,<br /> BestCount int,<br /> ActualCount int,<br /> LogicalFrag decimal,<br /> ExtentFrag decimal,<br /> RecCreatedDt datetime default getdate(),<br /> Status tinyint default 0,<br /> StartTime datetime,<br /> EndTime datetime,<br /> constraint pkc_fraglist__DatabaseName__ObjectOwner__ObjectName__IndexName_RecCreatedDt <br />primary key clustered (DatabaseName, ObjectOwner, ObjectName, IndexName, RecCreatedDt))<br /><br /><br />set nocount on<br /><br />-- delete archive over 90 days<br />delete admin.dbo.fraglist<br />where DatabaseName = @pDatabaseName<br />and RecCreatedDt &lt; getdate() - 90<br /><br />-- archive previous run<br />update admin.dbo.fraglist<br />set status = status + 10<br />where DatabaseName = @pDatabaseName<br />and status &lt; 10<br /><br />-- fragmentation study (find 1s and 4s)<br />select @sqlstr = 'use [' + @pDatabaseName + '] <br />declare @table_id int<br />declare @table varchar(100)<br /><br />if object_id(''tempdb.dbo.#fraglist'',''U'') is not null<br />drop table #fraglist<br />CREATE TABLE #fraglist (<br /> ObjectName varchar (255),<br /> ObjectId INT,<br /> IndexName varchar (255),<br /> IndexId INT,<br /> Lvl INT,<br /> CountPages INT,<br /> CountRows INT,<br /> MinRecSize INT,<br /> MaxRecSize INT,<br /> AvgRecSize INT,<br /> ForRecCount INT,<br /> Extents INT,<br /> ExtentSwitches INT,<br /> AvgFreeBytes INT,<br /> AvgPageDensity INT,<br /> ScanDensity DECIMAL,<br /> BestCount INT,<br /> ActualCount INT,<br /> LogicalFrag DECIMAL,<br /> ExtentFrag DECIMAL)<br /><br />set nocount on<br /><br />select @table_id = min(id) from dbo.sysobjects where type = ''U''<br />while @table_id is not null<br />begin<br />select @table = object_name(@table_id)<br />if @table not in (''dtproperties'')<br />insert #fraglist exec (''dbcc showcontig(['' + @table + '']) WITH FAST, TABLERESULTS, ALL_INDEXES'')<br />select @table_id = min(id) from dbo.sysobjects where type = ''U'' and id &gt; @table_id<br />end<br /><br />insert admin.dbo.fraglist (<br />DatabaseName,<br />ObjectOwner,<br />ObjectName,<br />ObjectId,<br />IndexName,<br />IndexId,<br />Lvl,<br />CountPages,<br />CountRows,<br />MinRecSize,<br />MaxRecSize,<br />AvgRecSize,<br />ForRecCount,<br />Extents,<br />ExtentSwitches,<br />AvgFreeBytes,<br />AvgPageDensity,<br />ScanDensity,<br />BestCount,<br />ActualCount,<br />LogicalFrag,<br />ExtentFrag,<br />Status)<br />select db_name(), <br />isnull(user_name(objectproperty(ObjectId, ''OwnerId'')),''dbo''),<br />ObjectName,<br />ObjectId,<br />IndexName,<br />IndexId,<br />Lvl,<br />CountPages,<br />CountRows,<br />MinRecSize,<br />MaxRecSize,<br />AvgRecSize,<br />ForRecCount,<br />Extents,<br />ExtentSwitches,<br />AvgFreeBytes,<br />AvgPageDensity,<br />ScanDensity,<br />BestCount,<br />ActualCount,<br />LogicalFrag,<br />ExtentFrag,<br />Status = case when IndexId = 0 -- heap<br />then 9 -- eliminate from consideration<br />when IndexId = 1 -- clustered index<br />then case when LogicalFrag &lt; 10 <br />then 9-- eliminate from consideration<br /> when CountPages &lt; 10000<br />then 4 -- reindex <br /> else 1 -- defrag<br /> end<br />when IndexId between 2 and 254 -- nonclustered index<br />then case when (select count(1)-- clustered will be defragged<br />from #fraglist <br />where ObjectName = ObjectName<br />and IndexId = 1<br />and LogicalFrag &gt;= 10<br />and CountPages &gt; 10000) &gt; 0<br />then case when LogicalFrag &lt; 10 <br />then 9-- eliminate from consideration<br /> when CountPages &lt; 10000<br />then 4 -- reindex <br /> else 1 -- defrag<br /> end<br />when (select count(1) -- clustered will be reindexed<br />from #fraglist <br />where ObjectName = ObjectName<br />and IndexId = 1<br />and LogicalFrag &gt;= 10<br />and CountPages &lt; 10000) &gt; 0<br />then 9 -- eliminate from consideration<br />else -- no clustered index on table<br />case when LogicalFrag &lt; 10<br />then 9-- eliminate from consideration<br /> when CountPages &lt; 10000<br />then 4 -- reindex <br /> else 1 -- defrag<br /> end<br />end<br />else 9 -- IndexId = 255 for text column pointer <br />end<br />from #fraglist'<br />exec sp_executesql @sqlStr<br /><br />-- perform identified required maintenance<br />declare indexesToMaintainList cursor <br />for<br />select ObjectOwner, ObjectName, IndexName, status<br />from admin.dbo.fraglist<br />where DatabaseName = @pDatabaseName<br />and ObjectName &lt;&gt; 'fraglist'<br />and status in (1,4)<br /><br />open indexesToMaintainList<br />fetch next from indexesToMaintainList into @ObjectOwner, @ObjectName, @IndexName, @status<br />while @@fetch_status = 0<br />begin<br />-- mark as current maintenance candidate<br />update admin.dbo.fraglist<br />set StartTime = getdate(),<br />status = case when @status = 1 then 2<br />when @status = 4 then 5<br />end<br />where DatabaseName = @pDatabaseName<br />and ObjectOwner = @ObjectOwner<br />and ObjectName = @ObjectName<br />and IndexName = @IndexName<br />and status in (1,4)<br /><br />if @status = 1<br />begin<br />set @sqlstr = 'DBCC INDEXDEFRAG([' + @pDatabaseName + '],[' + @ObjectName + '],[' + @IndexName + '])'<br />set @sqlstrStats = 'UPDATE STATISTICS [' + @pDatabaseName + '].' + @ObjectOwner + '.[' + @ObjectName + ']' + ' [' + @IndexName + '] WITH SAMPLE 100 PERCENT'<br />exec sp_executesql @sqlstr<br />exec sp_executesql @sqlstrStats<br />end<br /><br />if @status = 4<br />begin<br />set @sqlstr = 'DBCC DBREINDEX(''' + @pDatabaseName + '.' + @ObjectOwner + '.' + @ObjectName + ''',''' +@IndexName + ''')'<br />exec sp_executesql @sqlstr<br />end<br /><br />-- mark as maintenance complete<br />update admin.dbo.fraglist<br />set EndTime = getdate(),<br />status = case when @status = 1 then 3<br />when @status = 4 then 6<br />end<br />where DatabaseName = @pDatabaseName<br />and ObjectOwner = @ObjectOwner<br />and ObjectName = @ObjectName<br />and IndexName = @IndexName<br />and status in (2,5)<br /><br />fetch next from indexesToMaintainList into @ObjectOwner, @ObjectName, @IndexName, @status<br />end<br />deallocate indexesToMaintainList<br />GO<br /></pre><br />/Argyle
  18. Luis Martin Moderator

    I have good results reindexing critical tables once a week.

    Luis Martin
  19. kpyeung New Member

    I had ran throught this SP but some table's 'Scan Desity' still not equal to 100. Please guide me it is right or wrong. Moreover, the result cannot write to update dbo.fraglist table but the table indeed is created. As our SQL server didn't has the admin user so I changed the code from 'admin.dbo.fraglist' to 'dbo.draglist' is the problem cause it cannot write to the table? <br /><br />Thanks in advance and the below is my database stat. using DBCC showcontig<br /><br />DBCC SHOWCONTIG scanning 'sysobjects' table...<br />Table: 'sysobjects' (1); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 4<br />- Extents Scanned..............................: 4<br />- Extent Switches..............................: 3<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]<br />- Logical Scan Fragmentation ..................: 25.00%<br />- Extent Scan Fragmentation ...................: 75.00%<br />- Avg. Bytes Free per Page.....................: 3873.5<br />- Avg. Page Density (full).....................: 52.14%<br />DBCC SHOWCONTIG scanning 'sysindexes' table...<br />Table: 'sysindexes' (2); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 74<br />- Extents Scanned..............................: 23<br />- Extent Switches..............................: 55<br />- Avg. Pages per Extent........................: 3.2<br />- Scan Density [Best Count:Actual Count].......: 17.86% [10:56]<br />- Logical Scan Fragmentation ..................: 54.05%<br />- Extent Scan Fragmentation ...................: 95.65%<br />- Avg. Bytes Free per Page.....................: 3447.9<br />- Avg. Page Density (full).....................: 57.40%<br />DBCC SHOWCONTIG scanning 'syscolumns' table...<br />Table: 'syscolumns' (3); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 58<br />- Extents Scanned..............................: 21<br />- Extent Switches..............................: 32<br />- Avg. Pages per Extent........................: 2.8<br />- Scan Density [Best Count:Actual Count].......: 24.24% [8:33]<br />- Logical Scan Fragmentation ..................: 27.59%<br />- Extent Scan Fragmentation ...................: 90.48%<br />- Avg. Bytes Free per Page.....................: 3638.6<br />- Avg. Page Density (full).....................: 55.05%<br />DBCC SHOWCONTIG scanning 'systypes' table...<br />Table: 'systypes' (4); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Logical Scan Fragmentation ..................: 100.00%<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 6712.0<br />- Avg. Page Density (full).....................: 17.07%<br />DBCC SHOWCONTIG scanning 'syscomments' table...<br />Table: 'syscomments' (6); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 15<br />- Extents Scanned..............................: 5<br />- Extent Switches..............................: 5<br />- Avg. Pages per Extent........................: 3.0<br />- Scan Density [Best Count:Actual Count].......: 33.33% [2:6]<br />- Logical Scan Fragmentation ..................: 6.67%<br />- Extent Scan Fragmentation ...................: 40.00%<br />- Avg. Bytes Free per Page.....................: 3202.0<br />- Avg. Page Density (full).....................: 60.44%<br />DBCC SHOWCONTIG scanning 'sysfiles1' table...<br />Table: 'sysfiles1' (<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 6508.0<br />- Avg. Page Density (full).....................: 19.59%<br />DBCC SHOWCONTIG scanning 'syspermissions' table...<br />Table: 'syspermissions' (9); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Logical Scan Fragmentation ..................: 100.00%<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7700.0<br />- Avg. Page Density (full).....................: 4.87%<br />DBCC SHOWCONTIG scanning 'sysusers' table...<br />Table: 'sysusers' (10); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Logical Scan Fragmentation ..................: 100.00%<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7268.0<br />- Avg. Page Density (full).....................: 10.21%<br />DBCC SHOWCONTIG scanning 'sysdepends' table...<br />Table: 'sysdepends' (12); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Logical Scan Fragmentation ..................: 0.00%<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 62.0<br />- Avg. Page Density (full).....................: 99.23%<br />DBCC SHOWCONTIG scanning 'sysfilegroups' table...<br />Table: 'sysfilegroups' (96); index ID: 1, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Logical Scan Fragmentation ..................: 100.00%<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8058.0<br />- Avg. Page Density (full).....................: 0.44%<br />DBCC SHOWCONTIG scanning 'AT_AMLBHEAD-new' table...<br />Table: 'AT_AMLBHEAD-new' (34099162); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3<br />- Extents Scanned..............................: 3<br />- Extent Switches..............................: 2<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br />- Extent Scan Fragmentation ...................: 66.67%<br />- Avg. Bytes Free per Page.....................: 5954.3<br />- Avg. Page Density (full).....................: 26.44%<br />DBCC SHOWCONTIG scanning 'AT_AMLBDETL-new' table...<br />Table: 'AT_AMLBDETL-new' (50099219); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3<br />- Extents Scanned..............................: 3<br />- Extent Switches..............................: 2<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br />- Extent Scan Fragmentation ...................: 66.67%<br />- Avg. Bytes Free per Page.....................: 5678.0<br />- Avg. Page Density (full).....................: 29.85%<br />DBCC SHOWCONTIG scanning 'AT_AFSRJDEF' table...<br />Table: 'AT_AFSRJDEF' (66099276); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 12<br />- Extents Scanned..............................: 7<br />- Extent Switches..............................: 6<br />- Avg. Pages per Extent........................: 1.7<br />- Scan Density [Best Count:Actual Count].......: 28.57% [2:7]<br />- Extent Scan Fragmentation ...................: 57.14%<br />- Avg. Bytes Free per Page.....................: 1169.2<br />- Avg. Page Density (full).....................: 85.56%<br />DBCC SHOWCONTIG scanning 'AT_AFSRANCD' table...<br />Table: 'AT_AFSRANCD' (82099333); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 5833.0<br />- Avg. Page Density (full).....................: 27.93%<br />DBCC SHOWCONTIG scanning 'AT_AFSRACAT' table...<br />Table: 'AT_AFSRACAT' (98099390); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8022.0<br />- Avg. Page Density (full).....................: 0.89%<br />DBCC SHOWCONTIG scanning 'AT_AFSRCUR' table...<br />Table: 'AT_AFSRCUR' (114099447); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7893.0<br />- Avg. Page Density (full).....................: 2.48%<br />DBCC SHOWCONTIG scanning 'AT_AFSRJPST' table...<br />Table: 'AT_AFSRJPST' (130099504); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7991.0<br />- Avg. Page Density (full).....................: 1.27%<br />DBCC SHOWCONTIG scanning 'AT_AFSRRCUR' table...<br />Table: 'AT_AFSRRCUR' (146099561); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8023.0<br />- Avg. Page Density (full).....................: 0.88%<br />DBCC SHOWCONTIG scanning 'AT_AFSRNUMB' table...<br />Table: 'AT_AFSRNUMB' (16209961<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8014.0<br />- Avg. Page Density (full).....................: 0.99%<br />DBCC SHOWCONTIG scanning 'AT_AFTXINPH' table...<br />Table: 'AT_AFTXINPH' (178099675); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7802.0<br />- Avg. Page Density (full).....................: 3.61%<br />DBCC SHOWCONTIG scanning 'AT_AFBLACCT' table...<br />Table: 'AT_AFBLACCT' (194099732); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 90<br />- Extents Scanned..............................: 23<br />- Extent Switches..............................: 22<br />- Avg. Pages per Extent........................: 3.9<br />- Scan Density [Best Count:Actual Count].......: 52.17% [12:23]<br />- Extent Scan Fragmentation ...................: 69.57%<br />- Avg. Bytes Free per Page.....................: 504.7<br />- Avg. Page Density (full).....................: 93.76%<br />DBCC SHOWCONTIG scanning 'AT_AFRGFAFM' table...<br />Table: 'AT_AFRGFAFM' (210099789); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 104<br />- Extents Scanned..............................: 31<br />- Extent Switches..............................: 30<br />- Avg. Pages per Extent........................: 3.4<br />- Scan Density [Best Count:Actual Count].......: 41.94% [13:31]<br />- Extent Scan Fragmentation ...................: 87.10%<br />- Avg. Bytes Free per Page.....................: 626.0<br />- Avg. Page Density (full).....................: 92.27%<br />DBCC SHOWCONTIG scanning 'AT_AFRGFARW' table...<br />Table: 'AT_AFRGFARW' (226099846); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 48<br />- Extents Scanned..............................: 20<br />- Extent Switches..............................: 19<br />- Avg. Pages per Extent........................: 2.4<br />- Scan Density [Best Count:Actual Count].......: 30.00% [6:20]<br />- Extent Scan Fragmentation ...................: 85.00%<br />- Avg. Bytes Free per Page.....................: 769.1<br />- Avg. Page Density (full).....................: 90.50%<br />DBCC SHOWCONTIG scanning 'AT_AFRGRCID' table...<br />Table: 'AT_AFRGRCID' (242099903); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 4<br />- Extents Scanned..............................: 3<br />- Extent Switches..............................: 2<br />- Avg. Pages per Extent........................: 1.3<br />- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br />- Extent Scan Fragmentation ...................: 66.67%<br />- Avg. Bytes Free per Page.....................: 1015.0<br />- Avg. Page Density (full).....................: 87.46%<br />DBCC SHOWCONTIG scanning 'AT_AFRGFAAC' table...<br />Table: 'AT_AFRGFAAC' (258099960); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 62<br />- Extents Scanned..............................: 28<br />- Extent Switches..............................: 27<br />- Avg. Pages per Extent........................: 2.2<br />- Scan Density [Best Count:Actual Count].......: 28.57% [8:28]<br />- Extent Scan Fragmentation ...................: 85.71%<br />- Avg. Bytes Free per Page.....................: 859.0<br />- Avg. Page Density (full).....................: 89.39%<br />DBCC SHOWCONTIG scanning 'AT_AFRGFACL' table...<br />Table: 'AT_AFRGFACL' (274100017); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 29<br />- Extents Scanned..............................: 13<br />- Extent Switches..............................: 12<br />- Avg. Pages per Extent........................: 2.2<br />- Scan Density [Best Count:Actual Count].......: 30.77% [4:13]<br />- Extent Scan Fragmentation ...................: 76.92%<br />- Avg. Bytes Free per Page.....................: 475.2<br />- Avg. Page Density (full).....................: 94.13%<br />DBCC SHOWCONTIG scanning 'AT_AFRGRCAT' table...<br />Table: 'AT_AFRGRCAT' (290100074); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3<br />- Extents Scanned..............................: 3<br />- Extent Switches..............................: 2<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br />- Extent Scan Fragmentation ...................: 33.33%<br />- Avg. Bytes Free per Page.....................: 2616.0<br />- Avg. Page Density (full).....................: 67.68%<br />DBCC SHOWCONTIG scanning 'AT_AFTXINHD' table...<br />Table: 'AT_AFTXINHD' (32210018<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1190<br />- Extents Scanned..............................: 176<br />- Extent Switches..............................: 175<br />- Avg. Pages per Extent........................: 6.8<br />- Scan Density [Best Count:Actual Count].......: 84.66% [149:176]<br />- Extent Scan Fragmentation ...................: 98.86%<br />- Avg. Bytes Free per Page.....................: 204.1<br />- Avg. Page Density (full).....................: 97.48%<br />DBCC SHOWCONTIG scanning 'AT_AFTXLEDG' table...<br />Table: 'AT_AFTXLEDG' (338100245); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 7088<br />- Extents Scanned..............................: 903<br />- Extent Switches..............................: 902<br />- Avg. Pages per Extent........................: 7.8<br />- Scan Density [Best Count:Actual Count].......: 98.12% [886:903]<br />- Extent Scan Fragmentation ...................: 95.90%<br />- Avg. Bytes Free per Page.....................: 238.0<br />- Avg. Page Density (full).....................: 97.06%<br />DBCC SHOWCONTIG scanning 'AT_AFTXDETL' table...<br />Table: 'AT_AFTXDETL' (354100302); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 5000<br />- Extents Scanned..............................: 640<br />- Extent Switches..............................: 639<br />- Avg. Pages per Extent........................: 7.8<br />- Scan Density [Best Count:Actual Count].......: 97.66% [625:640]<br />- Extent Scan Fragmentation ...................: 99.38%<br />- Avg. Bytes Free per Page.....................: 294.5<br />- Avg. Page Density (full).....................: 96.36%<br />DBCC SHOWCONTIG scanning 'AT_AFTXDESC' table...<br />Table: 'AT_AFTXDESC' (370100359); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 4999<br />- Extents Scanned..............................: 639<br />- Extent Switches..............................: 638<br />- Avg. Pages per Extent........................: 7.8<br />- Scan Density [Best Count:Actual Count].......: 97.81% [625:639]<br />- Extent Scan Fragmentation ...................: 99.37%<br />- Avg. Bytes Free per Page.....................: 292.9<br />- Avg. Page Density (full).....................: 96.38%<br />DBCC SHOWCONTIG scanning 'AT_AFSYULOG' table...<br />Table: 'AT_AFSYULOG' (386100416); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 4<br />- Extents Scanned..............................: 4<br />- Extent Switches..............................: 3<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]<br />- Extent Scan Fragmentation ...................: 75.00%<br />- Avg. Bytes Free per Page.....................: 8094.0<br />- Avg. Page Density (full).....................: 0.00%<br />DBCC SHOWCONTIG scanning 'AT_AMSRCHRG' table...<br />Table: 'AT_AMSRCHRG' (405576483); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 5306.0<br />- Avg. Page Density (full).....................: 34.45%<br />DBCC SHOWCONTIG scanning 'AT_ALSRCURR' table...<br />Table: 'AT_ALSRCURR' (421576540); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8030.0<br />- Avg. Page Density (full).....................: 0.79%<br />DBCC SHOWCONTIG scanning 'AT_AMSRBANK' table...<br />Table: 'AT_AMSRBANK' (437576597); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 3.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 1054.7<br />- Avg. Page Density (full).....................: 86.97%<br />DBCC SHOWCONTIG scanning 'AT_AMSRASCT' table...<br />Table: 'AT_AMSRASCT' (453576654); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7152.0<br />- Avg. Page Density (full).....................: 11.64%<br />DBCC SHOWCONTIG scanning 'AT_AMSRBKAC' table...<br />Table: 'AT_AMSRBKAC' (469576711); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 2<br />- Extents Scanned..............................: 2<br />- Extent Switches..............................: 1<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]<br />- Extent Scan Fragmentation ...................: 50.00%<br />- Avg. Bytes Free per Page.....................: 4456.0<br />- Avg. Page Density (full).....................: 44.95%<br />DBCC SHOWCONTIG scanning 'AT_AMSRBKID' table...<br />Table: 'AT_AMSRBKID' (48557676<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 39<br />- Extents Scanned..............................: 9<br />- Extent Switches..............................: 8<br />- Avg. Pages per Extent........................: 4.3<br />- Scan Density [Best Count:Actual Count].......: 55.56% [5:9]<br />- Extent Scan Fragmentation ...................: 44.44%<br />- Avg. Bytes Free per Page.....................: 794.0<br />- Avg. Page Density (full).....................: 90.19%<br />DBCC SHOWCONTIG scanning 'AT_AMDIARYT' table...<br />Table: 'AT_AMDIARYT' (501576825); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 6008.0<br />- Avg. Page Density (full).....................: 25.77%<br />DBCC SHOWCONTIG scanning 'AT_AFBLMOVE' table...<br />Table: 'AT_AFBLMOVE' (514100872); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 641<br />- Extents Scanned..............................: 111<br />- Extent Switches..............................: 110<br />- Avg. Pages per Extent........................: 5.8<br />- Scan Density [Best Count:Actual Count].......: 72.97% [81:111]<br />- Extent Scan Fragmentation ...................: 98.20%<br />- Avg. Bytes Free per Page.....................: 439.6<br />- Avg. Page Density (full).....................: 94.57%<br />DBCC SHOWCONTIG scanning 'AT_AMASSOCA' table...<br />Table: 'AT_AMASSOCA' (517576882); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 8920<br />- Extents Scanned..............................: 1135<br />- Extent Switches..............................: 1134<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 98.24% [1115:1135]<br />- Extent Scan Fragmentation ...................: 67.93%<br />- Avg. Bytes Free per Page.....................: 392.1<br />- Avg. Page Density (full).....................: 95.16%<br />DBCC SHOWCONTIG scanning 'AT_AFTXJNTM' table...<br />Table: 'AT_AFTXJNTM' (530100929); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 85<br />- Extents Scanned..............................: 26<br />- Extent Switches..............................: 25<br />- Avg. Pages per Extent........................: 3.3<br />- Scan Density [Best Count:Actual Count].......: 42.31% [11:26]<br />- Extent Scan Fragmentation ...................: 96.15%<br />- Avg. Bytes Free per Page.....................: 833.8<br />- Avg. Page Density (full).....................: 89.70%<br />DBCC SHOWCONTIG scanning 'AT_AMBLCHGE' table...<br />Table: 'AT_AMBLCHGE' (533576939); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 935<br />- Extents Scanned..............................: 125<br />- Extent Switches..............................: 124<br />- Avg. Pages per Extent........................: 7.5<br />- Scan Density [Best Count:Actual Count].......: 93.60% [117:125]<br />- Extent Scan Fragmentation ...................: 56.80%<br />- Avg. Bytes Free per Page.....................: 394.0<br />- Avg. Page Density (full).....................: 95.13%<br />DBCC SHOWCONTIG scanning 'AT_AFTXRCUR' table...<br />Table: 'AT_AFTXRCUR' (546100986); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 9<br />- Extents Scanned..............................: 7<br />- Extent Switches..............................: 6<br />- Avg. Pages per Extent........................: 1.3<br />- Scan Density [Best Count:Actual Count].......: 28.57% [2:7]<br />- Extent Scan Fragmentation ...................: 71.43%<br />- Avg. Bytes Free per Page.....................: 1923.4<br />- Avg. Page Density (full).....................: 76.24%<br />DBCC SHOWCONTIG scanning 'AT_AMBLTRAX' table...<br />Table: 'AT_AMBLTRAX' (549576996); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 78543<br />- Extents Scanned..............................: 9829<br />- Extent Switches..............................: 9828<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.89% [9818:9829]<br />- Extent Scan Fragmentation ...................: 73.52%<br />- Avg. Bytes Free per Page.....................: 1572.5<br />- Avg. Page Density (full).....................: 80.57%<br />DBCC SHOWCONTIG scanning 'AT_AFTXBUDG' table...<br />Table: 'AT_AFTXBUDG' (562101043); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 405<br />- Extents Scanned..............................: 79<br />- Extent Switches..............................: 78<br />- Avg. Pages per Extent........................: 5.1<br />- Scan Density [Best Count:Actual Count].......: 64.56% [51:79]<br />- Extent Scan Fragmentation ...................: 87.34%<br />- Avg. Bytes Free per Page.....................: 367.7<br />- Avg. Page Density (full).....................: 95.46%<br />DBCC SHOWCONTIG scanning 'AT_AMDNHEAD' table...<br />Table: 'AT_AMDNHEAD' (565577053); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 65038<br />- Extents Scanned..............................: 8140<br />- Extent Switches..............................: 8139<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.88% [8130:8140]<br />- Extent Scan Fragmentation ...................: 83.92%<br />- Avg. Bytes Free per Page.....................: 1601.1<br />- Avg. Page Density (full).....................: 80.22%<br />DBCC SHOWCONTIG scanning 'AT_AMDNTRAX' table...<br />Table: 'AT_AMDNTRAX' (581577110); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 743<br />- Extents Scanned..............................: 142<br />- Extent Switches..............................: 141<br />- Avg. Pages per Extent........................: 5.2<br />- Scan Density [Best Count:Actual Count].......: 65.49% [93:142]<br />- Extent Scan Fragmentation ...................: 83.10%<br />- Avg. Bytes Free per Page.....................: 372.8<br />- Avg. Page Density (full).....................: 95.39%<br />DBCC SHOWCONTIG scanning 'AT_AFRGFARP_TMP' table...<br />Table: 'AT_AFRGFARP_TMP' (594101157); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 165<br />- Extents Scanned..............................: 27<br />- Extent Switches..............................: 26<br />- Avg. Pages per Extent........................: 6.1<br />- Scan Density [Best Count:Actual Count].......: 77.78% [21:27]<br />- Extent Scan Fragmentation ...................: 92.59%<br />- Avg. Bytes Free per Page.....................: 7526.1<br />- Avg. Page Density (full).....................: 7.02%<br />DBCC SHOWCONTIG scanning 'AT_AMSSCONF' table...<br />Table: 'AT_AMSSCONF' (597577167); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7827.0<br />- Avg. Page Density (full).....................: 3.30%<br />DBCC SHOWCONTIG scanning 'AT_AMLBSTUB_09u-err' table...<br />Table: 'AT_AMLBSTUB_09u-err' (610101214); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 2<br />- Extents Scanned..............................: 2<br />- Extent Switches..............................: 1<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]<br />- Extent Scan Fragmentation ...................: 50.00%<br />- Avg. Bytes Free per Page.....................: 3208.0<br />- Avg. Page Density (full).....................: 60.37%<br />DBCC SHOWCONTIG scanning 'AT_AMCBMAST' table...<br />Table: 'AT_AMCBMAST' (613577224); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 2786<br />- Extents Scanned..............................: 363<br />- Extent Switches..............................: 362<br />- Avg. Pages per Extent........................: 7.7<br />- Scan Density [Best Count:Actual Count].......: 96.14% [349:363]<br />- Extent Scan Fragmentation ...................: 76.86%<br />- Avg. Bytes Free per Page.....................: 253.3<br />- Avg. Page Density (full).....................: 96.87%<br />DBCC SHOWCONTIG scanning 'AT_AMLBCHEQ_09u-err' table...<br />Table: 'AT_AMLBCHEQ_09u-err' (626101271); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 1584.0<br />- Avg. Page Density (full).....................: 80.43%<br />DBCC SHOWCONTIG scanning 'AT_AMCNHEAD' table...<br />Table: 'AT_AMCNHEAD' (629577281); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7274.0<br />- Avg. Page Density (full).....................: 10.13%<br />DBCC SHOWCONTIG scanning 'AT_AMLBTXBT_09u-err' table...<br />Table: 'AT_AMLBTXBT_09u-err' (64210132<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7517.0<br />- Avg. Page Density (full).....................: 7.13%<br />DBCC SHOWCONTIG scanning 'AT_AMSRAUTO' table...<br />Table: 'AT_AMSRAUTO' (64557733<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8046.0<br />- Avg. Page Density (full).....................: 0.59%<br />DBCC SHOWCONTIG scanning 'AT_AMSRVSET' table...<br />Table: 'AT_AMSRVSET' (658101385); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3<br />- Extents Scanned..............................: 3<br />- Extent Switches..............................: 2<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br />- Extent Scan Fragmentation ...................: 66.67%<br />- Avg. Bytes Free per Page.....................: 4246.0<br />- Avg. Page Density (full).....................: 47.54%<br />DBCC SHOWCONTIG scanning 'AT_AMARAUTO' table...<br />Table: 'AT_AMARAUTO' (661577395); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 13454<br />- Extents Scanned..............................: 1686<br />- Extent Switches..............................: 1685<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.76% [1682:1686]<br />- Extent Scan Fragmentation ...................: 94.90%<br />- Avg. Bytes Free per Page.....................: 397.6<br />- Avg. Page Density (full).....................: 95.09%<br />DBCC SHOWCONTIG scanning 'AT_AMARPYTX' table...<br />Table: 'AT_AMARPYTX' (677577452); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 28701<br />- Extents Scanned..............................: 3594<br />- Extent Switches..............................: 3593<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.83% [3588:3594]<br />- Extent Scan Fragmentation ...................: 92.71%<br />- Avg. Bytes Free per Page.....................: 177.1<br />- Avg. Page Density (full).....................: 97.81%<br />DBCC SHOWCONTIG scanning 'AT_AMLBHEAD-26M' table...<br />Table: 'AT_AMLBHEAD-26M' (690101499); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 4012<br />- Extents Scanned..............................: 517<br />- Extent Switches..............................: 516<br />- Avg. Pages per Extent........................: 7.8<br />- Scan Density [Best Count:Actual Count].......: 97.10% [502:517]<br />- Extent Scan Fragmentation ...................: 97.29%<br />- Avg. Bytes Free per Page.....................: 394.9<br />- Avg. Page Density (full).....................: 95.12%<br />DBCC SHOWCONTIG scanning 'AT_AMARPYHD' table...<br />Table: 'AT_AMARPYHD' (693577509); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 555<br />- Extents Scanned..............................: 128<br />- Extent Switches..............................: 127<br />- Avg. Pages per Extent........................: 4.3<br />- Scan Density [Best Count:Actual Count].......: 54.69% [70:128]<br />- Extent Scan Fragmentation ...................: 90.63%<br />- Avg. Bytes Free per Page.....................: 756.9<br />- Avg. Page Density (full).....................: 90.65%<br />DBCC SHOWCONTIG scanning 'AT_AMLBLSTD' table...<br />Table: 'AT_AMLBLSTD' (706101556); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 495<br />- Extents Scanned..............................: 85<br />- Extent Switches..............................: 84<br />- Avg. Pages per Extent........................: 5.8<br />- Scan Density [Best Count:Actual Count].......: 72.94% [62:85]<br />- Extent Scan Fragmentation ...................: 95.29%<br />- Avg. Bytes Free per Page.....................: 509.2<br />- Avg. Page Density (full).....................: 93.71%<br />DBCC SHOWCONTIG scanning 'AT_AMARPYAL' table...<br />Table: 'AT_AMARPYAL' (709577566); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 28264<br />- Extents Scanned..............................: 3540<br />- Extent Switches..............................: 3539<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.80% [3533:3540]<br />- Extent Scan Fragmentation ...................: 93.45%<br />- Avg. Bytes Free per Page.....................: 232.5<br />- Avg. Page Density (full).....................: 97.13%<br />DBCC SHOWCONTIG scanning 'AT_AMLBDETL-26M' table...<br />Table: 'AT_AMLBDETL-26M' (722101613); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3774<br />- Extents Scanned..............................: 490<br />- Extent Switches..............................: 489<br />- Avg. Pages per Extent........................: 7.7<br />- Scan Density [Best Count:Actual Count].......: 96.33% [472:490]<br />- Extent Scan Fragmentation ...................: 96.33%<br />- Avg. Bytes Free per Page.....................: 401.1<br />- Avg. Page Density (full).....................: 95.04%<br />DBCC SHOWCONTIG scanning 'AT_AMAROPEN' table...<br />Table: 'AT_AMAROPEN' (725577623); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 32961<br />- Extents Scanned..............................: 4132<br />- Extent Switches..............................: 4131<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.73% [4121:4132]<br />- Extent Scan Fragmentation ...................: 93.73%<br />- Avg. Bytes Free per Page.....................: 211.2<br />- Avg. Page Density (full).....................: 97.39%<br />DBCC SHOWCONTIG scanning 'AT_AMOAITEM-err' table...<br />Table: 'AT_AMOAITEM-err' (741577680); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 268<br />- Extents Scanned..............................: 37<br />- Extent Switches..............................: 36<br />- Avg. Pages per Extent........................: 7.2<br />- Scan Density [Best Count:Actual Count].......: 91.89% [34:37]<br />- Extent Scan Fragmentation ...................: 78.38%<br />- Avg. Bytes Free per Page.....................: 252.4<br />- Avg. Page Density (full).....................: 96.88%<br />DBCC SHOWCONTIG scanning 'AT_AMSRSTNO' table...<br />Table: 'AT_AMSRSTNO' (757577737); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 5718.0<br />- Avg. Page Density (full).....................: 29.36%<br />DBCC SHOWCONTIG scanning 'AT_AMAIBDAC' table...<br />Table: 'AT_AMAIBDAC' (773577794); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7439.0<br />- Avg. Page Density (full).....................: 8.09%<br />DBCC SHOWCONTIG scanning 'AT_AMANFGFA' table...<br />Table: 'AT_AMANFGFA' (789577851); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7276.0<br />- Avg. Page Density (full).....................: 10.11%<br />DBCC SHOWCONTIG scanning 'AT_AMOAITEM' table...<br />Table: 'AT_AMOAITEM' (821577965); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 596<br />- Extents Scanned..............................: 106<br />- Extent Switches..............................: 105<br />- Avg. Pages per Extent........................: 5.6<br />- Scan Density [Best Count:Actual Count].......: 70.75% [75:106]<br />- Extent Scan Fragmentation ...................: 92.45%<br />- Avg. Bytes Free per Page.....................: 371.0<br />- Avg. Page Density (full).....................: 95.42%<br />DBCC SHOWCONTIG scanning 'AT_AMSRUNIT_15A_eg952' table...<br />Table: 'AT_AMSRUNIT_15A_eg952' (834102012); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 7560<br />- Extents Scanned..............................: 948<br />- Extent Switches..............................: 947<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.68% [945:948]<br />- Extent Scan Fragmentation ...................: 53.80%<br />- Avg. Bytes Free per Page.....................: 1579.7<br />- Avg. Page Density (full).....................: 80.48%<br />DBCC SHOWCONTIG scanning 'AT_AMSRUNIT_15A_CG952' table...<br />Table: 'AT_AMSRUNIT_15A_CG952' (850102069); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 7653<br />- Extents Scanned..............................: 959<br />- Extent Switches..............................: 958<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.79% [957:959]<br />- Extent Scan Fragmentation ...................: 38.58%<br />- Avg. Bytes Free per Page.....................: 1579.5<br />- Avg. Page Density (full).....................: 80.49%<br />DBCC SHOWCONTIG scanning 'AT_AMSRCHRG_Cht' table...<br />Table: 'AT_AMSRCHRG_Cht' (866102126); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 5306.0<br />- Avg. Page Density (full).....................: 34.45%<br />DBCC SHOWCONTIG scanning 'AT_AFSRPERD' table...<br />Table: 'AT_AFSRPERD' (869578136); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 2804.0<br />- Avg. Page Density (full).....................: 65.36%<br />DBCC SHOWCONTIG scanning 'AT_AMASSOCA_24a' table...<br />Table: 'AT_AMASSOCA_24a' (882102183); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 8571<br />- Extents Scanned..............................: 1073<br />- Extent Switches..............................: 1072<br />- Avg. Pages per Extent........................: 8.0<br />- Scan Density [Best Count:Actual Count].......: 99.91% [1072:1073]<br />- Extent Scan Fragmentation ...................: 39.24%<br />- Avg. Bytes Free per Page.....................: 382.7<br />- Avg. Page Density (full).....................: 95.27%<br />DBCC SHOWCONTIG scanning 'AT_AFSRMACT' table...<br />Table: 'AT_AFSRMACT' (885578193); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 2047<br />- Extents Scanned..............................: 278<br />- Extent Switches..............................: 277<br />- Avg. Pages per Extent........................: 7.4<br />- Scan Density [Best Count:Actual Count].......: 92.09% [256:278]<br />- Extent Scan Fragmentation ...................: 23.38%<br />- Avg. Bytes Free per Page.....................: 299.9<br />- Avg. Page Density (full).....................: 96.29%<br />DBCC SHOWCONTIG scanning 'AT_AMSRPTAG' table...<br />Table: 'AT_AMSRPTAG' (898102240); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 8426<br />- Extents Scanned..............................: 1067<br />- Extent Switches..............................: 1066<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 98.78% [1054:1067]<br />- Extent Scan Fragmentation ...................: 99.34%<br />- Avg. Bytes Free per Page.....................: 339.5<br />- Avg. Page Density (full).....................: 95.81%<br />DBCC SHOWCONTIG scanning 'AT_AMLBHEAD' table...<br />Table: 'AT_AMLBHEAD' (930102354); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 11471<br />- Extents Scanned..............................: 1448<br />- Extent Switches..............................: 1447<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 99.03% [1434:1448]<br />- Extent Scan Fragmentation ...................: 97.65%<br />- Avg. Bytes Free per Page.....................: 411.7<br />- Avg. Page Density (full).....................: 94.91%<br />DBCC SHOWCONTIG scanning 'AT_AMLBDETL' table...<br />Table: 'AT_AMLBDETL' (96210246<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 10871<br />- Extents Scanned..............................: 1373<br />- Extent Switches..............................: 1372<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 98.98% [1359:1373]<br />- Extent Scan Fragmentation ...................: 98.11%<br />- Avg. Bytes Free per Page.....................: 394.0<br />- Avg. Page Density (full).....................: 95.13%<br />DBCC SHOWCONTIG scanning 'AT_AMLBSTUB_09u_err_again' table...<br />Table: 'AT_AMLBSTUB_09u_err_again' (978102525); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 3312.0<br />- Avg. Page Density (full).....................: 59.08%<br />DBCC SHOWCONTIG scanning 'AT_AMLBCHEQ_09u_err_again' table...<br />Table: 'AT_AMLBCHEQ_09u_err_again' (994102582); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 4576.0<br />- Avg. Page Density (full).....................: 43.46%<br />DBCC SHOWCONTIG scanning 'AT_AMLBTXBT_09u_err_again' table...<br />Table: 'AT_AMLBTXBT_09u_err_again' (1010102639); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7517.0<br />- Avg. Page Density (full).....................: 7.13%<br />DBCC SHOWCONTIG scanning 'AT_AMLBSTUB' table...<br />Table: 'AT_AMLBSTUB' (1026102696); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 9<br />- Extents Scanned..............................: 8<br />- Extent Switches..............................: 7<br />- Avg. Pages per Extent........................: 1.1<br />- Scan Density [Best Count:Actual Count].......: 25.00% [2:8]<br />- Extent Scan Fragmentation ...................: 75.00%<br />- Avg. Bytes Free per Page.....................: 8049.8<br />- Avg. Page Density (full).....................: 0.55%<br />DBCC SHOWCONTIG scanning 'AT_AMLBCHEQ' table...<br />Table: 'AT_AMLBCHEQ' (1042102753); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 8<br />- Extents Scanned..............................: 7<br />- Extent Switches..............................: 6<br />- Avg. Pages per Extent........................: 1.1<br />- Scan Density [Best Count:Actual Count].......: 14.29% [1:7]<br />- Extent Scan Fragmentation ...................: 71.43%<br />- Avg. Bytes Free per Page.....................: 8059.3<br />- Avg. Page Density (full).....................: 0.43%<br />DBCC SHOWCONTIG scanning 'AT_AMLBTXBT' table...<br />Table: 'AT_AMLBTXBT' (1058102810); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 6<br />- Extents Scanned..............................: 5<br />- Extent Switches..............................: 4<br />- Avg. Pages per Extent........................: 1.2<br />- Scan Density [Best Count:Actual Count].......: 20.00% [1:5]<br />- Extent Scan Fragmentation ...................: 80.00%<br />- Avg. Bytes Free per Page.....................: 8091.3<br />- Avg. Page Density (full).....................: 0.03%<br />DBCC SHOWCONTIG scanning 'AT_AFSSCNFG' table...<br />Table: 'AT_AFSSCNFG' (1061578820); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7923.0<br />- Avg. Page Density (full).....................: 2.11%<br />DBCC SHOWCONTIG scanning 'AT_AMDNAUTO' table...<br />Table: 'AT_AMDNAUTO' (1077578877); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8023.0<br />- Avg. Page Density (full).....................: 0.88%<br />DBCC SHOWCONTIG scanning 'AT_AMSRPTAG_20M' table...<br />Table: 'AT_AMSRPTAG_20M' (1269579561); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 5649<br />- Extents Scanned..............................: 717<br />- Extent Switches..............................: 716<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 98.61% [707:717]<br />- Extent Scan Fragmentation ...................: 99.44%<br />- Avg. Bytes Free per Page.....................: 334.6<br />- Avg. Page Density (full).....................: 95.87%<br />DBCC SHOWCONTIG scanning 'AT_AMAICGDB' table...<br />Table: 'AT_AMAICGDB' (1317579732); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8014.0<br />- Avg. Page Density (full).....................: 0.99%<br />DBCC SHOWCONTIG scanning 'AT_AMLBHEAD-29j' table...<br />Table: 'AT_AMLBHEAD-29j' (1365579903); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3444<br />- Extents Scanned..............................: 440<br />- Extent Switches..............................: 439<br />- Avg. Pages per Extent........................: 7.8<br />- Scan Density [Best Count:Actual Count].......: 97.95% [431:440]<br />- Extent Scan Fragmentation ...................: 98.64%<br />- Avg. Bytes Free per Page.....................: 397.4<br />- Avg. Page Density (full).....................: 95.09%<br />DBCC SHOWCONTIG scanning 'AT_AMOAPAYT' table...<br />Table: 'AT_AMOAPAYT' (1477580302); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 7928.0<br />- Avg. Page Density (full).....................: 2.05%<br />DBCC SHOWCONTIG scanning 'AT_AMDNPLOG' table...<br />Table: 'AT_AMDNPLOG' (1573580644); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 13398<br />- Extents Scanned..............................: 1689<br />- Extent Switches..............................: 1688<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 99.17% [1675:1689]<br />- Extent Scan Fragmentation ...................: 97.39%<br />- Avg. Bytes Free per Page.....................: 361.9<br />- Avg. Page Density (full).....................: 95.53%<br />DBCC SHOWCONTIG scanning 'AT_AMDPCTRL' table...<br />Table: 'AT_AMDPCTRL' (160558075<img src='/community/emoticons/emotion-11.gif' alt='8)' />; index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 17971<br />- Extents Scanned..............................: 2261<br />- Extent Switches..............................: 2260<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 99.38% [2247:2261]<br />- Extent Scan Fragmentation ...................: 97.08%<br />- Avg. Bytes Free per Page.....................: 322.3<br />- Avg. Page Density (full).....................: 96.02%<br />DBCC SHOWCONTIG scanning 'AT_AMDNCUTD' table...<br />Table: 'AT_AMDNCUTD' (1621580815); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 5424<br />- Extents Scanned..............................: 693<br />- Extent Switches..............................: 692<br />- Avg. Pages per Extent........................: 7.8<br />- Scan Density [Best Count:Actual Count].......: 97.84% [678:693]<br />- Extent Scan Fragmentation ...................: 98.99%<br />- Avg. Bytes Free per Page.....................: 410.9<br />- Avg. Page Density (full).....................: 94.92%<br />DBCC SHOWCONTIG scanning 'AT_AMLBLSTD-29j' table...<br />Table: 'AT_AMLBLSTD-29j' (1669580986); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 430<br />- Extents Scanned..............................: 63<br />- Extent Switches..............................: 62<br />- Avg. Pages per Extent........................: 6.8<br />- Scan Density [Best Count:Actual Count].......: 85.71% [54:63]<br />- Extent Scan Fragmentation ...................: 95.24%<br />- Avg. Bytes Free per Page.....................: 425.6<br />- Avg. Page Density (full).....................: 94.74%<br />DBCC SHOWCONTIG scanning 'AT_AMLBDETL-29j' table...<br />Table: 'AT_AMLBDETL-29j' (1685581043); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3316<br />- Extents Scanned..............................: 422<br />- Extent Switches..............................: 421<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 98.34% [415:422]<br />- Extent Scan Fragmentation ...................: 99.05%<br />- Avg. Bytes Free per Page.....................: 388.3<br />- Avg. Page Density (full).....................: 95.20%<br />DBCC SHOWCONTIG scanning 'AT_AMLBSTUB-20j' table...<br />Table: 'AT_AMLBSTUB-20j' (1717581157); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 4<br />- Extents Scanned..............................: 4<br />- Extent Switches..............................: 3<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]<br />- Extent Scan Fragmentation ...................: 75.00%<br />- Avg. Bytes Free per Page.....................: 2012.0<br />- Avg. Page Density (full).....................: 75.14%<br />DBCC SHOWCONTIG scanning 'AT_AMLBCHEQ-20j' table...<br />Table: 'AT_AMLBCHEQ-20j' (1733581214); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 3<br />- Extents Scanned..............................: 3<br />- Extent Switches..............................: 2<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br />- Extent Scan Fragmentation ...................: 66.67%<br />- Avg. Bytes Free per Page.....................: 5514.7<br />- Avg. Page Density (full).....................: 31.87%<br />DBCC SHOWCONTIG scanning 'AT_AMLBTXBT-20j' table...<br />Table: 'AT_AMLBTXBT-20j' (1749581271); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 2<br />- Extents Scanned..............................: 2<br />- Extent Switches..............................: 1<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]<br />- Extent Scan Fragmentation ...................: 50.00%<br />- Avg. Bytes Free per Page.....................: 7324.0<br />- Avg. Page Density (full).....................: 9.51%<br />DBCC SHOWCONTIG scanning 'AT_AMDITEMP' table...<br />Table: 'AT_AMDITEMP' (1861581670); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 1<br />- Extents Scanned..............................: 1<br />- Extent Switches..............................: 0<br />- Avg. Pages per Extent........................: 1.0<br />- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]<br />- Extent Scan Fragmentation ...................: 0.00%<br />- Avg. Bytes Free per Page.....................: 8082.0<br />- Avg. Page Density (full).....................: 0.15%<br />DBCC SHOWCONTIG scanning 'AT_AMSRESTE' table...<br />Table: 'AT_AMSRESTE' (1977058079); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 8<br />- Extents Scanned..............................: 4<br />- Extent Switches..............................: 3<br />- Avg. Pages per Extent........................: 2.0<br />- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]<br />- Extent Scan Fragmentation ...................: 50.00%<br />- Avg. Bytes Free per Page.....................: 1563.0<br />- Avg. Page Density (full).....................: 80.69%<br />DBCC SHOWCONTIG scanning 'AT_AMSRBLDG' table...<br />Table: 'AT_AMSRBLDG' (1993058136); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 17<br />- Extents Scanned..............................: 4<br />- Extent Switches..............................: 3<br />- Avg. Pages per Extent........................: 4.3<br />- Scan Density [Best Count:Actual Count].......: 75.00% [3:4]<br />- Extent Scan Fragmentation ...................: 50.00%<br />- Avg. Bytes Free per Page.....................: 580.4<br />- Avg. Page Density (full).....................: 92.83%<br />DBCC SHOWCONTIG scanning 'AT_AMSRUNIT' table...<br />Table: 'AT_AMSRUNIT' (2009058193); index ID: 0, database ID: 16<br />TABLE level scan performed.<br />- Pages Scanned................................: 7967<br />- Extents Scanned..............................: 1006<br />- Extent Switches..............................: 1005<br />- Avg. Pages per Extent........................: 7.9<br />- Scan Density [Best Count:Actual Count].......: 99.01% [996:1006]<br />- Extent Scan Fragmentation ...................: 18.79%<br />- Avg. Bytes Free per Page.....................: 1580.2<br />- Avg. Page Density (full).....................: 80.48%<br />DBCC execution completed. If DBCC printed error messages, contact your system administrator.<br /><br /><br />
  20. satya Moderator

    What is the schedule of DBCC DBREINDEX on the database?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  21. kpyeung New Member

    As it is a trial run on my testing machine, I ran the SP instantly without schedule.
  22. satya Moderator

  23. Luis Martin Moderator

    1) First tables are system tables, there is nothing to do and not neccesary.
    2) Rest of tables, user tables, index 0 means table itself so there is no way usign DBCC to deframent it. Only way is to export, recreate and import table and also is not neccesay.
    So begin to worry when user table with index not = 0 are fragmented.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  24. ranjan_scjd New Member

    quote:Originally posted by ykchakri

    The 'Scandensity' and 'Extent scan fragmentation' values of the DBCC SHOWCONTIG command can help you decide when to re-build the index. For a fully re-built index, the scandensity will be close to 100% and the 'Extent scan fragmentation' will be close to 0%.
    In my case, I've created a small procedure that runs once a week and checks these values on every index and runs 'DBCC INDEXDEFRAG' on those indexes that are having these values beyond certain pre-defined limits.

    Hi...

    Can you please share the code what you have developed for weekly reindexing or index defragmenting the most fragmented tables.


    Regards
    Ranjan Rashmi Sahoo
    MphasiS BFL Ltd. Bangalore

    Follow the Truth, Explore the Truth, Implement the Truth.

Share This Page