SQL Server Performance

Index Size

Discussion in 'Performance Tuning for DBAs' started by Arman, Feb 22, 2008.

  1. Arman New Member

    Hi All, Can some one help me that how can i find the size the index. Also Can some one have the script that will give me all the indexes and their sizes..
    Thanks
  2. ranjitjain New Member

    In sql 2000, SQL server stores indexes information in system table i.e. sysindexes.
    Youy can query above table to get all the names of indexes and size of the index.
    size can be retrived as dpages*8 K

Share This Page