January 7, 2003 at 3:08 am
Hi,
Do you know how I could do some maintenance tasks (like dbreindex) on the system tables to improve the performance.
I know that you cannot reindex the system tables but we have SAP databases and within each databases there are over 26000 tables and for example the sysobjects table is very havyly fregmanted.
Should I just leave as is or are there some technics?
Any advice?
Bye
Gabor
January 7, 2003 at 4:14 am
Try DBCC UPDATEUSAGE (DB Name)
January 7, 2003 at 5:20 am
Hi,
Antares686: I don't know whether this DBCC SHOWCONTIG is useful in this case or not?
SaNaZ
January 7, 2003 at 5:29 am
For shure I did it.
I'm running regullary the maintenance tasks on the DB (INDEXDEFRAG, REINDEX, UPDATEUSAGE, UPDATE STATISTTICS, CHECKDB) but non of this is working on system tables.
On the other hand updateusage corrects just the entries within the sysindex tables to help the optimiser to choose the right index. It doesn't defragment the table or index
Here is the showcontig output of my sysobjects:
DBCC SHOWCONTIG scanning 'sysobjects' table...
Table: 'sysobjects' (1); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 3098
- Extents Scanned..............................: 416
- Extent Switches..............................: 3097
- Avg. Pages per Extent........................: 7.4
- Scan Density [Best Count:Actual Count].......: 12.52% [388:3098]
- Logical Scan Fragmentation ..................: 49.58%
- Extent Scan Fragmentation ...................: 99.04%
- Avg. Bytes Free per Page.....................: 2440.8
- Avg. Page Density (full).....................: 69.84%
Bye
Gabor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply