ValleyENT
asked on
SQL Server Buildout/Config
Experts,
Getting ready to upgrade our primary application and going off of some guildlines for their recommend build out configuration and this is what i've got. Any input on this would be great. This is a SQL 2005 box that takes a pretty hefty load.
1. HP DL580 G5, Quad DC Xeon's at 2.8ghz, 64GB of RAM
2. RAID CONFIG
(4) 74GB 15K RPM Drives in RAID 1+0; Operating System + Page File
(4) 74GB 15K RPM Drives in RAID 1+0; LOGS, SQL LDF's, W/ 16 GB
(10) 74GB 15K RPM Drives in RAID 1+0 on HP Storage Works SAS; SQL.EXE and DB's
3. Windows Server 2003 Enterprise 64bit, SQL Server 2005 Standard 64bit
This may seem overkill to some, but it is required. I am more concerned about how the load is spread between raid ie - should SQL be installed on seperate raid for optimum performance. Any input in this regard would be appreciated.
Thanks in advance~
Getting ready to upgrade our primary application and going off of some guildlines for their recommend build out configuration and this is what i've got. Any input on this would be great. This is a SQL 2005 box that takes a pretty hefty load.
1. HP DL580 G5, Quad DC Xeon's at 2.8ghz, 64GB of RAM
2. RAID CONFIG
(4) 74GB 15K RPM Drives in RAID 1+0; Operating System + Page File
(4) 74GB 15K RPM Drives in RAID 1+0; LOGS, SQL LDF's, W/ 16 GB
(10) 74GB 15K RPM Drives in RAID 1+0 on HP Storage Works SAS; SQL.EXE and DB's
3. Windows Server 2003 Enterprise 64bit, SQL Server 2005 Standard 64bit
This may seem overkill to some, but it is required. I am more concerned about how the load is spread between raid ie - should SQL be installed on seperate raid for optimum performance. Any input in this regard would be appreciated.
Thanks in advance~
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good point! Buy the iLo Advanced license for that and you won't regret a penny of the cost.
ASKER
I will be configuring ILO for sure. The log files are much smaller than the database so I didn't think I would need more that 4 drives and wouldn't require the massive quanitty of spindles.
ASKER
Thanks.
I guess the last piece of the puzzle is why Server 2003 and SQL 2005?
Are you also going to get the HP ILO license? well worth the additional $$