July 26, 2006 at 1:45 pm
we have recently moved our SQL database to a SAN drive because of performance issues, I am planning out how to align the tables / indexes on this SAN drive. I would like any advice on if i can improve the performance of replication by locating specific tables on dedicated clustered drives and if so what tables.
I have already moved all indexes to a clusted drive of their own.
July 31, 2006 at 8:00 am
This was removed by the editor as SPAM
July 31, 2006 at 12:17 pm
It depends on your DB. If you have large tables you might want to put them in a separate file group or sep drive. Obviously log will be on a diff drive. Also you can put indexes on diff drive or diff file group. These are some general guidelines. I think there is some article on sqlserverperformance regarding this.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply