High index Space - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

High index Space

Author

Topic

martind1
Starting Member

28 Posts

Posted - 2012-03-29 : 10:06:08

Hi,

I have come accross a table in my database that has a high index space.
On one of the tables the data space is 470mb but the index space is 2.8GB.
This seems very excessive or is this normal?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-29 : 13:23:19

It depends. I wouldn't say that's abnormal. Indexes are needed to speed queries up. Do you need all of those indexes for your queries? Probably.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources