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

Extents Allocated > 200 Expand / Collapse
Author
Message
Posted Thursday, January 24, 2008 10:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:28 AM
Points: 154, Visits: 338
We are running a DB performance monitor. It shows extents allocated >200. We run DBCC SHOWCONTIG on a table and shows:
Scan density is 20%
Logical Scan Fragmemtation is 40%
Extent Scan Fragmentation is 77%

others show:

Scan density is 66%
Logical Scan Fragmemtation is 0%
Extent Scan Fragmentation is 66%

Is there a problem here and if so how do I fix? We have run DBCC REINDEX on the tables but it did not correct the numbers.

thanks,
Post #447056
Posted Thursday, January 24, 2008 11:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
You might want to run a DBCC UPDATEUSAGE to ensure you're still receiving the correct numbers.

---
SQLSlayer
Making SQL do what we want it to do.

Post #447114
Posted Thursday, January 24, 2008 11:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:28 AM
Points: 154, Visits: 338
That's the scary part, we did run updateusage!!!
Post #447115
Posted Thursday, January 24, 2008 11:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:24 PM
Points: 7,139, Visits: 15,191
Does this table have a clustered index? Because heaps (tables without a clustered index) essentially can't be defragmented: the only way to approximate it is to create another table and copy all records into the new table.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #447119
Posted Thursday, January 24, 2008 12:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:28 AM
Points: 154, Visits: 338
Great, thanks, there are no clustered indexes on the table.

Post #447133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse