August 10, 2004 at 11:09 am
Looking for advise on setting up a new Sql server. I'm getting an 8-way server with 15 GB of Ram. Two internal harddrives @ 73 GB each. Plus an external array with 14 harddirves @ 73 GB each. I will be installing Sql 2000 Enterprise Ed, sp3a on a Windows 2003 Enterprise Ed OS. The questions running through my mind are: how do I setup my memory, use the /PAE switch or just AWE (I want Sql to use as much as possible)? I plan on mirroring the 2 internal HDs to come up with 73 gb usable. The external array is another story, do I just do a Raid 5 with a spare drive in case of failure or should I do mirroring? I have a total of eight databases that will run on the new server for a total of 56 MB with the largest being 44 GB. Should I try to place the largest db on it own mirrored partition and the rest on another mirrored partition?
August 13, 2004 at 8:00 am
This was removed by the editor as SPAM
August 16, 2004 at 9:48 am
On our server, we mirrored the c drive. On the external array, we went with Raid 10. It seemed to give us better performance over the Raid 5 configuration.
HTH
John
August 17, 2004 at 3:55 pm
Well, I just went ahead and mirror the OS and did a raid 5 on my external arrary. Wow 820 GB of available space.
August 17, 2004 at 7:18 pm
Sounds like you doesn't need 820GB spaces. I would go to separtate the transaction log with two disk mirrored and create RAID 10 array for database files with the rest of disks.
In terms of memory configuration, Adding /PAE to boot.ini and enable AWE in SQL Server. To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply