February 27, 2002 at 12:48 pm
We have a Peoplesoft Financials database coming down the pipe soon being migrated from Oracle to SQL Server. This database in Oracle is approx. 10GB.
On SQL Server, how should I initially set this Database up for optimal performance ?
(2 MDF files, etc.....)
February 27, 2002 at 1:20 pm
For 10g I think one mdf will be fine. I'd say start there and if you have performance issues, then consider filegroups as one of many possible solutions. My reasons for using filegroups would be because I cant physically get all the data on one RAID set or because I can't complete an entire db backup in the time allowed.
Andy
February 27, 2002 at 1:23 pm
Tend to agree with Andy, though I'd add that you would want a separate physical device for the ldf.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply