SQL Server Performance Forum – Threads Archive
SQL2K5 server setup
Hi, As per Joe earlier advise, I am thinking to go ahead with setup of SQL2K5. PowerEdge 28502x73Gx10K RPM (OS/SQL/TEMP DB) – RAID 1 (76GB)
2x36Gx15K RPM (Log files for active DB) – RAID 1 (36GB) PoweValut220
10x146Gx10K RPM (Database files) – RAID 10 (usable 730GB).
(The reason for me to go for 146 is size increment- today we have about 200GB image database, which is going to be triple in coming 1-2 years.) Just to highlight here, I have 2 databases. 1 database is actively used and other database is only use to store and extract images (these images are already stored and user will only view or download these images). This is the reason I am trying to put LOG file of active database to Separate Array and not of database with images. I wanted to make a big RAID 10 to create space of 730GB over 10 SCSI Drives. Now my question is
-> Do I put 2 Raid cards, one with 2 internal channels and other with 2 external channels?
-> Attach my PowerValut with 1 external Channel (as there will be only Single Raid 10)?
-> Connect both internal RAID 1 to different Channels? This will be my first time for setting up such a huge database system, I will appreciate some comments. Yah another thing, this Web site don’t have huge data entry process. Mainly is query oriented system not data entry oriented, user will see information about listing and do bidding (some thing like eBay). As this is not data entry process and is not write intensive process, do I go with RAID 5 or RAID 10? Regards,
Waqar.
Based on the input on the application usage I would go with RAID5, which is suitable. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi Satya, Is there any rule of thumb to identify if one must use RAID 5 based on number of write to database?
e.g.; 100 Read / 10 Write?
http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_022206.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx
.. though refers SQL 2000 but still applicable to 2005. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>