mah_j (11/18/2012)
But i can not test any thing on main server.Is there any other way to find the hot index?
this can help you here http://msdn.microsoft.com/en-us/library/ms188917(v=sql.90).aspx
mah_j (11/18/2012)
What do you mean by partitioning?Do you mean using partitioning with an appropriate range of data in that table to separate the files?
yes , in this way you can shift the IO oerhead to other data files (disks/drives)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)