Sunday, February 19, 2012

HW Requirement for SQL Server 2005

We are running four servers at different sites say A,B,C and D and want
it to connect main Server at head office what would be the
configuration of main server for running SQL Server 2005.There are two
database say X and Y at each server at sites A,B,C and D. X requires
37.4 MB memory while Y requires 154 MB memory. 500 records are
populated in X database at each site While 30000 records are populated
in Y database at each site. What would be HW requirement for SQL
Server?
With regards
Ali Raza RajputHi
Hardware requirements are not just about volumes, other factors need to be
taken into consideration such as response, resilience and recovery. In a
distributed architecture you also need to consider network issues and
connectivity, not just the server on it's own. If you are looking at
replication you should also consider additional hardware if you need to
separate publishers from the distributors. You give no indication of future
volumes or growth rates, this and other unanwered questions make it very
difficult to answer you question. I suggest that you analyse you requirement
s
in more detail and talk to a hardware vendor.
John
"perhiyar" wrote:

> We are running four servers at different sites say A,B,C and D and want
> it to connect main Server at head office what would be the
> configuration of main server for running SQL Server 2005.There are two
> database say X and Y at each server at sites A,B,C and D. X requires
> 37.4 MB memory while Y requires 154 MB memory. 500 records are
> populated in X database at each site While 30000 records are populated
> in Y database at each site. What would be HW requirement for SQL
> Server?
>
> With regards
> Ali Raza Rajput
>

No comments:

Post a Comment