Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

index space inside data file Expand / Collapse
Author
Message
Posted Saturday, May 22, 2010 8:43 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, August 14, 2014 9:46 AM
Points: 743, Visits: 1,055
Hi,

I have analised the space of my datafile and i have a dought...
I have used the reports of SQL Server 2005 to see the space used by my database.


the report stats that my datafile as 51 % of the space used by indexs and 38 % used by data.

Is this normal ? (the space used by the indexs is bigger that the space used by the data)

Why this is appening?

Thank you.
Post #926418
Posted Saturday, May 22, 2010 9:09 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:43 AM
Points: 21,632, Visits: 15,292
It is quite possible that the index space is including your clustered indexes.

Try running the scripts shown in this article:
http://jasonbrimhall.info/2010/05/19/tablespace-update/




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #926420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse