Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?
Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

Software/Hardware used:
ASKED: March 4, 2008  11:33 PM
UPDATED: March 5, 2008  1:34 PM

Answer Wiki:
Yes, absolutely! Providing you have enough storage space to hold the data and there is enough horsepower in the server to handle the transactions the two databases' transactions. Regardless, two databases should not be a problem at all. Most places use one server with multiple databases on them-- it just makes sense with the cost of the licensing costs for a SQL Server. I've seen 30 or 40 databases on one server (most were low traffic/usage-- several hundred calls in a business day) and I'm certain there are bigger installations out there as well. Depending on the amount of horse power and RAM that you have you can host hundreds of databases on a single SQL Server. By default SQL Server ships with 4 databases already which are the system databases.
Last Wiki Answer Submitted:  March 5, 2008  5:31 am  by  Jerry Lees   5,320 pts.
All Answer Wiki Contributors:  Jerry Lees   5,320 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.