DB creation

  • 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.....)

  • 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

  • Tend to agree with Andy, though I'd add that you would want a separate physical device for the ldf.

    Steve Jones

    steve@dkranch.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply