October 1, 2008 at 11:02 am
i have 17 tables replicated to web application out oh which 3-4 tables are historical now my application is running slow, how can i find optimum level of indexing on tables.
thanks
October 1, 2008 at 11:08 am
Tuning indexes on tables associated with replication can be a bit fun. You do need to make sure that the indexes you have in place for queries are necessary as that of course is more costly on replicated inserts, updates, deletes. Depending on the nature of the data and the change rate you may find that you need to rebuild them more often than other indexes so, do some monitoring on the fragmentation. Additionally, you should certainly consider updating statistics on those tables / indexes more frequently if you determine that you can't rebuild the indexes on a more regular basis.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply