Extents Allocated

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Extents Allocated > 200

Extents Allocated > 200

Rate Topic

Display Mode

Topic Options

Author

Message

Dana Bibeault

Posted Thursday, January 24, 2008 10:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 12:29 PM
Points: 154, Visits: 333

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

Adam Bean

Posted Thursday, January 24, 2008 11:31 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 8:30 AM
Points: 1,106, Visits: 1,792

You might want to run a DBCC UPDATEUSAGE to ensure you're still receiving the correct numbers.

--

Post #447114

Dana Bibeault

Posted Thursday, January 24, 2008 11:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 12:29 PM
Points: 154, Visits: 333

That's the scary part, we did run updateusage!!!

Post #447115

Matt Miller (#4)

Posted Thursday, January 24, 2008 11:39 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:45 PM
Points: 7,002, Visits: 13,999

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

Dana Bibeault

Posted Thursday, January 24, 2008 12:01 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 12:29 PM
Points: 154, Visits: 333

Great, thanks, there are no clustered indexes on the table.

Post #447133

« Prev Topic | Next Topic »

Permissions