index space inside data file

  • 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.

  • 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, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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