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 capacity calculation Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 5:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
Hello guys,


Are there any guidelines in giving an estimate with regards the storage for non-clustered indexes on an existing table.

Kind regards
Post #1442699
Posted Tuesday, April 16, 2013 6:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:18 AM
Points: 5,315, Visits: 9,736
Add up the width of each column in the index, then add the width of the clustering key, and multiply the whole lot by the number of rows in the table (assuming we're not talking about a filtered index). That'll give you an approximate figure, but bear in mind that it can be influenced by fill factors, non-leaf pages (if you have a lot of of rows in your table) and the number of rows that can fit on one data page (if your index is particularly wide).

John
Post #1442704
Posted Tuesday, April 16, 2013 7:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
Thanks alot
Post #1442726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse