Database Server and SQL Setup Query

Posted on 2011-05-10
Last Modified: 2012-05-11
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...

Question by:collie3
    1 Comment
    LVL 15

    Accepted Solution

    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

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now