I have a server that i would like to use as a dedicated DB Server. It is running Win Server 2k3 and SQL Server 2005. The typical upstream bandwidth is anywhere from 384Kb/s to 700Kb/s. Is this enough to host multiple SQL Server 2005 DB's?
The DB's will be used for database driven websites.
Please let me know what your thoughts are.
Thanks,
The answer varies on opinion... but as long as you don't over-use the database, you should be alright.
This answer, of course, changes as soon as your site get's really busy / large amounts of data need to move - but you could sit your presentation layer on top of some web services and implement caching on the web services to reduce the database traffic for most of your select operations.
Also, if multiple databases means more than 3 or 4 you could end up with a lot of connections that you might want to manage.
No comments:
Post a Comment