I have a new hp server with 6 72 gig drives, when we upgrade to 3.7 they say our database will be 8.5-9 gigs, What setup will give me optimum performance. From what i have read, i know I will have to change to a multi file / multi disk configuration. How big can i make my database files before performances suffers, Please note that these six disk and this server are only going to be used for navision and the os. server is a 2.8 xeon, 1 gig of ram.
Around 4Gb per part is ok.