By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

HW Requirement for SQL Server 2005

P: n/a
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

May 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I'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" <db*******@gmail.com> wrote in message
news:11**********************@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

May 20 '06 #2

P: n/a
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
May 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.