Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES question Expand / Collapse
Author
Message
Posted Friday, December 12, 2008 12:13 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 5:20 AM
Points: 751, Visits: 1,561
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??


Post #618862
Posted Friday, December 12, 2008 12:18 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:41 PM
Points: 31,080, Visits: 15,525
rebuild indexes.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #618870
Posted Friday, December 12, 2008 1:32 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 5:20 AM
Points: 751, Visits: 1,561
Thanks!

I did a DBREINDEX on all tables in my DB (individually) using this format:

use MYDB
DBCC DBREINDEX ('MYDB.Territories', '', 70)

After doing this, the logical fragmentation and extent fragmentation numbers are still VERY high.. like 98 and 99%????




Post #618909
Posted Friday, December 12, 2008 6:40 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 5:20 AM
Points: 751, Visits: 1,561
DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES




  Post Attachments 
uw_worksheet.xlsx (73 views, 15.75 KB)
Post #619011
Posted Monday, December 15, 2008 4:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
As per books online:

Logical Scan Fragmentation Percentage of out-of-order pages returned from scanning the leaf pages of an index. This number is not relevant to heaps and text indexes.

Extent Scan Fragmentation Percentage of out-of-order extents in scanning the leaf pages of an index. This number is not relevant to heaps.

You should not consider these numbers for heaps. In the sheet attached by you this can be easily depicted.

MJ
Post #619469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse