• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Database Server and SQL Setup Query

We currently have 3 seperate applications which have SQL databases, all  installed on one windows 2003 server. We now have a fourth system which also requires SQL Server. I would like some advice on what is the best way to setup databases in SQL.

Would it be best practice to install the application on a seperate server and just link the database back to the database server.

Then to tidy this up...
Move all applications onto a seperate server and keep this server as just a database server.

How many databases can SQL Server 2005 standard handle before you setup a second database server?

I would like to implement a strategy now and tidy this up...

1 Solution
Walter RitzelSenior Software EngineerCommented:
From architectural perspective, app and database should reside in different servers.
Now, how many databases a server can support is a hard question to determine. You need to weight on memory, disk space, number of cpu cores just from hardware perspective. Then, from a database perspective, you need to weight how intense is the usage on each one of the database schemas, growth rate of each database... for example, databases that are mission critical usually have their own servers... apps that are not mission critical could share a server, using the points mentioned above to make the correct dimensioning.

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now