Search
InstantDoc ID
GO

Browse By: Author | Issue

October 17, 2005 03:17 PM

Piecing Together Fragmentation

SQL Server 2005 provides a wealth of information about fragmentation
Rating: (0)
Kalen Delaney
SQL Server Magazine
InstantDoc ID #48129
Last month, we looked at the specifications for calling the new sys.dm_db _index_physical_stats() table-valued function (TVF) in SQL Server 2005. This function, which replaces DBCC SHOWCONTIG, returns information about the physical organization of your data structures.This function can return information about any SQL Server 2005 object—including tables, indexes, and indexed views—that needs physical storage. Let's look at the meaning of some of the returned information.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

I have a special case in SQL2005 of a table using the clause textImage_on. The table has a clustered index and a LOB column. The table has and a very high number of ghost_record_count (more than 90% of all rows) as if it was a heap. The value come from the row for which the alloc_unit_type_desc = 'LOB_DATA'. We indeed deleted a lot of records from this table. Worst we are not able to reclaim space storage on the table usign alter index rebuild ... with lob_compaction. Is textimage_on clause could be responsible for it ?

Maurice3/10/2008 11:03:14 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.