The information you provided is not sufficient to determine the hardware
specs. Additional info like the number of concurrent users, transactions per
second, and the complexity of the transactions would greatly help.
Unfortunately, even with all that additonal info, estimating the required
hardware specs is a bit of crapshoot for people who just read your post.
If you can afford it, don't go out and purchase the server before you have
had a chance to run a prototype of it in your dev environment.
Another way is to compare this app with a known app, and use the server
specs of that known app as a guide.
Linchi
[quoted text, click to view] "Slimo" wrote:
> Hello,
>
> I would appreciate if someone can give some advice on hardware for building
> up SQL 2005 cluster. We will have 4 database of 50 GB each. How many
> processors, memory,... do I need? My preference is to go for HP servers
>
> Thanks in advance
>
>
>
>
Thanks for the reply. We will have about 4.000.000 records and each day 400
records could be modified. Regarding the concurrent users we could have 2000
users making request through web application. Lest's say that I start with 2
servers (dual processors and 8 GB ram). Is it ok? If the performance are not
ok can I just add another server in the cluster to obtain more performance
Thanks
[quoted text, click to view] "Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:7D593F4B-5D48-4AF4-BE94-25675AD64150@microsoft.com...
> The information you provided is not sufficient to determine the hardware
> specs. Additional info like the number of concurrent users, transactions
> per
> second, and the complexity of the transactions would greatly help.
> Unfortunately, even with all that additonal info, estimating the required
> hardware specs is a bit of crapshoot for people who just read your post.
>
> If you can afford it, don't go out and purchase the server before you have
> had a chance to run a prototype of it in your dev environment.
>
> Another way is to compare this app with a known app, and use the server
> specs of that known app as a guide.
>
> Linchi
>
> "Slimo" wrote:
>
>> Hello,
>>
>> I would appreciate if someone can give some advice on hardware for
>> building
>> up SQL 2005 cluster. We will have 4 database of 50 GB each. How many
>> processors, memory,... do I need? My preference is to go for HP servers
>>
>> Thanks in advance
>>
>>
>>
>>
>>
You can't just add a box to get more performance. Clustering is a badly
overloaded term in computing. In the SQL world, it is a failover technology
to helpo achieve higher system availability. It is not a scale-out
technology.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
[quoted text, click to view] "Slimo" <slimard001@yahoo.fr> wrote in message
news:e2BcqwUhGHA.1272@TK2MSFTNGP03.phx.gbl...
> Thanks for the reply. We will have about 4.000.000 records and each day
> 400 records could be modified. Regarding the concurrent users we could
> have 2000 users making request through web application. Lest's say that I
> start with 2 servers (dual processors and 8 GB ram). Is it ok? If the
> performance are not ok can I just add another server in the cluster to
> obtain more performance
>
> Thanks
>
> "Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
> news:7D593F4B-5D48-4AF4-BE94-25675AD64150@microsoft.com...
>> The information you provided is not sufficient to determine the hardware
>> specs. Additional info like the number of concurrent users, transactions
>> per
>> second, and the complexity of the transactions would greatly help.
>> Unfortunately, even with all that additonal info, estimating the required
>> hardware specs is a bit of crapshoot for people who just read your post.
>>
>> If you can afford it, don't go out and purchase the server before you
>> have
>> had a chance to run a prototype of it in your dev environment.
>>
>> Another way is to compare this app with a known app, and use the server
>> specs of that known app as a guide.
>>
>> Linchi
>>
>> "Slimo" wrote:
>>
>>> Hello,
>>>
>>> I would appreciate if someone can give some advice on hardware for
>>> building
>>> up SQL 2005 cluster. We will have 4 database of 50 GB each. How many
>>> processors, memory,... do I need? My preference is to go for HP servers
>>>
>>> Thanks in advance
>>>
>>>
>>>
>>>
>>>
>
>
