September 9, 2005 at 1:33 pm
I have a silly question. Can you run multiple software packages on one SQL Server instance? We have three separate SQL Server applications - Maximo, SMS, and HEAT. Currently, all three are being run on separate SQL Server instances, on three separate network servers. We are looking at putting them all one network server, in a single SQL Server instance.
I do not have a lot of experience with SQL Server (obviously) and am not sure exactly how this will work. I am just curious if this is standard practice.
Thanks!!
September 9, 2005 at 2:49 pm
Standard answer: it depends.
In theory the answer is Yes. SQL/Server can handle several databases on the same instance.
In practice, it depends on the load each application generates. If they are only generating a light load (CPU, I/O and network traffic), go for it. If any of the applications generates a heavy load (don't forget the peaks), it probably would be better to leave it on the dedicated server. In between: it depends on the pressure to move to a single server - don't fix it if it ain't broke.
"In theory, theory and practice are the same. In practice they aren't".
Enjoy consolidating
Regards
Otto
Otto Schreibke
The future is a foreign country, they do things differently there.
(Stolen from Arthur C Clarke)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply