DBCC DBREINDEX and Logical Fragmentation

Question

DBCC DBREINDEX and Logical Fragmentation

Viewing 7 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

How big are those tables? How many pages?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

T_Peters Hall of Fame Points: 3052 More actions · Answer 2

They are very small tables, 1 page and a dozen to 2 dozen rows. I doubt they are a performance issue, but why does the Logical Fragmentation go to 100?

Thanks,

Tim

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Because fragmentation has very little meaning on such small tables. Logical fragmentation is defined as the number of out of order pages. With only 1 page in the table it's meaningless.

Don't worry about it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

T_Peters Hall of Fame Points: 3052 More actions · Answer 4

T_Peters

Hall of Fame

Points: 3052

May 5, 2008 at 1:03 pm

#810867

Thanks, it was more curiosity not worry 😀

neil-560592 SSCommitted Points: 1557 More actions · Answer 5

GilaMonster (5/5/2008)
Because fragmentation has very little meaning on such small tables. Logical fragmentation is defined as the number of out of order pages. With only 1 page in the table it's meaningless.
Don't worry about it.

How large do tables have to be to start showing effects of fragmentation (in rows or pages)?

http://90.212.51.111 domain

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 6

I can't remember offhand. I did read it somewhere.

I think it's around 100 pages, but don't quote me on that. I'll see if I can find the source article tomorrow.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

neil-560592 SSCommitted Points: 1557 More actions · Answer 7

neil-560592

SSCommitted

Points: 1557

May 5, 2008 at 3:56 pm

#810967

Thanks

http://90.212.51.111 domain