Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-12-12 : 14:15:03
|
| If I run DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES against my SQL Server 2000 database and see High Extent Fragmentation and logical Fragmentation numbers, what is the recommended way to remedy this?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-12-12 : 15:32:08
|
| I did a DBREINDEX on all tables in my DB (individually) using this format: use MYDBDBCC DBREINDEX ('MYDB.Territories', '', 70)After doing this, the logical fragmentation and extent fragmentation numbers are still VERY high.. like 98 and 99%???? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-12 : 17:23:04
|
quote:
Originally posted by jpotucek
I did a DBREINDEX on all tables in my DB (individually) using this format: use MYDBDBCC DBREINDEX ('MYDB.Territories', '', 70)After doing this, the logical fragmentation and extent fragmentation numbers are still VERY high.. like 98 and 99%????
Is your table heap(without clustered index) What do you get scan density with DBCC showcontig? |
|
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2008-12-12 : 20:25:59
|
| In case table does not have clustered index and you want to defrag it - in that case you may want to add a primary key (temporary) like IDENTITY column and do the defrag and then remove it. But this involves time in case if your table is large - just a thoughtTechnologyYogihttp://gvphubli.blogspot.com/ |
|
|
|
|
|
|
DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES