MS SQL Server - Index size

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Index size

Zack

2006-11-15, 7:14 pm

Is it normal for Index size to be three times the size of its corresponding
table in SQL 2005

Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA

2006-11-15, 7:14 pm

It does not look normal to me. It may be fragmented

did you run

SELECT * FROM sys. dm_db_index_physical
_stats
(DB_ID(N',<your db name>'), OBJECT_ID(N'<your table table>'), NULL, NULL
, 'DETAILED');

and check the avg_fragmentation_in
_percent ?

"Zack" wrote:

> Is it normal for Index size to be three times the size of its corresponding
> table in SQL 2005
>
>
>

Ken

2006-11-15, 7:14 pm

Zack wrote:
> Is it normal for Index size to be three times the size of its corresponding
> table in SQL 2005

Its possible for this to occur. If there is a fillfactor set to a low
percentage and the table has little number of columns.

Sponsored Links