• SQLSACT (12/18/2012)


    I have confirmed with the App team that it is to be expected for this time and I can expect even more growth

    if this is expected and confirmed then growth should not be a suspect here , data will grow.... its in nature. another thing if , as you say that there are less reads as compare to insert then having 23 indexes there only putting extra overhead in terms of both space and DML operation (here insert) as other people suggested here that use dm_db_index_usage and wipe out all indexes those are not in use.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)