Hi, I was hoping I could get some advice on disk utlitization. I have a 2008 r2 instance, with a 600GB disk that holds the data (34 databases). I have a recurring issue where there is very heavy disk activity on 1 database in particular (its 80GB) server has 16GB memory and 4 processors. I dont really see much cpu activity, but when proccessing takes place on this database the server slows waaay down, and processes againbst other dbs take forever. I was wondering if there is anything to be gained by moving the mdf for this database onto a separate disk drive from the other databases? Thanks, Zoe

Hi Zoe, there could be so many factors, What exactly activity is happening ( Loading data, index creation , extraction , updates, Deletes etc). If all 35 DBs are using same disk then yes putting your 80GB DB on separate disk will be good impact on performance. You might need to study more and see what exactly is happening at the time it get slow or it is always slow. Also this is Reporting Services forum. pleas ask your question on DATABASE Design Forum to get proper answer. http://social.msdn.microsoft.com/Forums/en-US/databasedesign/threads Thank you http://sqlage.blogspot.com/

Hi Zoe, there could be so many factors, What exactly activity is happening ( Loading data, index creation , extraction , updates, Deletes etc). If all 35 DBs are using same disk then yes putting your 80GB DB on separate disk will be good impact on performance. You might need to study more and see what exactly is happening at the time it get slow or it is always slow. Also this is Reporting Services forum. pleas ask your question on DATABASE Design Forum to get proper answer. http://social.msdn.microsoft.com/Forums/en-US/databasedesign/threads Thank you http://sqlage.blogspot.com/

Hi Aamir, thanks so much - Ill repost on another forum Cheers, Zoe