June 29, 2008 at 12:24 pm
I'm configuing a new SQL server for my company and I could use a little guidance. I have currently configured a HP Proliant DL 380 with 2 Xeon 5440 processors, 12 GB ram, 6 72GB 15k drives on a single Smary Array P400 with 512MB and battery backup. I intend on setting up 2 drives in RAID 1 for OS/Transaction Logs and 4 drives in a RAID 10 for data. This sever will house the databases for our ERP system and document archiving system. The total amount of data is currently around 25 GB and growing. How does this configuration sound?
June 29, 2008 at 4:32 pm
Sounds OK. Couple questions
Where do backups go?
How much RAM to SQL Server?
Does the ERP system make heavy use of tempdb? Might need a R1 array for it and an R1 for data. 25GB isn't much data.
Any metrics from past servers?
June 29, 2008 at 4:46 pm
Sorry that I didn't provide more information. This is my first attempt at settting up a SQL server and my CDW server specialist help me configure the it. Our current server is running Windows 2003 and SQL Server 2000 and is setup entirely one RAID 5 with 3 146 GB 15k SCSI drvies. The ERP database hasn't been migrated from Foxpro to it yet so any metrics would be incorrect. We plan to migrate from Foxpro 9 to SQL Server 2005.
What do you think about the following?
Raid 1 - OS/Backup
Raid 10 - Data
Raid 1 - Transaction Logs
I'm open for comments and suggestions so please let me know what you think.
June 29, 2008 at 4:49 pm
Actually, the server rep originally configured it with 2 36GB 15k SAS drives in RAID 1 for the OS and 4 146K 10k SAS drives for everything else. I didn't think that was right but I am inexperienced in this area.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply