We have a SQL Server 2005 Standart server with two databases which are used by tons of applications. The server seems to slow down at certain times of day due to high traffic. We're certainly going to scale up but we also have a few Compaq Proliant servers lying around doing nothing and I thought maybe we should scale out instead. At first I thought of dividing the two databases into separate servers but they each have tables that the other depends on so we fear that it could be slow when we separate them. Could you please give me any suggestions about scaling out for having a faster running database system?
It is not easy to give advice based on such a tiny description, and usually
However, you may want to look in some specific areas - that may or may not fit your systems topology and design. Sorry if some items are pretty obvious, but, again, it is hard to provide targeted and relevant advices from just a small description.
Regarding the scaling, it depends actually how your two databases are linked, and how much cost it would take for the developers to use the tables from two different servers. If, fortunately, you can give it a try, ensure the two DB servers can communicate efficiently, via a 1Gb link for instance.
No. Not possible. Simple like that. In general. Basically buy faster hardware or optimize your code.