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 RajputI'd be more concerned with the connectivity between servers, what latency
will you accept?

It also depends how many users are querying the new server, what's its
purpose?

--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials

"perhiyar" <dba.hilal@.gmail.com> wrote in message
news:1148108985.178205.178820@.i40g2000cwc.googlegr oups.com...
> 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|||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?

Now, do you have a centralized server or not? It's not fully clear to
me what you are trying to accomplish but with this "volume" of data
nearly all server hardware will pull this off easily if you don't do
overly complex calculations. As Tony pointed out, network latency is
probably more of an issue here - depending on the connectivity.

Regards

robert