SQL Server Performance Forum – Threads Archive

Hardware and host recommendations for hosted SQL

I am evaluating using a hosted SQL server and would like feedback regarding my options.
This is for 50-75 concurrent users, mostly reading data, ~20gb database. Softlayer has this option: Server Dual Processor Dual Core Opteron 2220 – 2.8GHz – 4 x 1MB cache $379.00/month
Ram 4 GB DDRII Registered 667 $50.00/month
Disk System 4 x 73GB 15k RPM SA-SCSI RAID 10 $250/month
Database Software Microsoft SQL Server 2005 Workgroup (32bit) $120.00/month I realize the storage is less than ideal with only 4 disks, but that is the max they offer.
Is this system adequate or does another host offer better (yet still cost effective) solutions for SQL server? Thanks!

Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

it is hard to tell if hosting is included,
or is this just the hardware
ask to separate
in general, i do not like to rent equipment from the HP web site
ProLiant DL385G2
2 x Opteron 2218 2.6GHz
4x1GB memory
4 x 72GB 15K
$7902 Dell PowerEdge 2900
2 x Xeon 5150 2.66GHz
4 x 1 GB memory
4 x 73GB 15K
$5092 so you are goin g to pay $679/mo for how long (exl SW)

Luis and Joe – thank you for your feedback. We are going the hosted route because this is for an Internet application. It would cost $1,000s to get even a 10mb/s connection without the redundant carriers offered by the host. So, I guess it comes down to this: If we are limited to 4 disks:
(2) RAID 1 – OS / log files
(2) RAID 1 – data files Or
(4) RAID 10 – OS, log, and data files Which is going to be faster? And roughly how much faster would this be:
(2) RAID 1 – OS
(4) RAID 10 – data I realize it is highly application dependent, but all other factors being equal, how do these configurations compare? Thank you so much for your quick responses.

i think you should look for a host provider that lets you rent space and bandwidth
and put your own equipment there
i know some that have purchase arrangements with hw vendors it taking a quick look at the softlayer site,
i do seriously suggest you look for another provider

]]>