Multiple Instances of SQL Server

Is it a good idea to install multiple instances of SQL Server one one
server in a production environment? I've always heard that it isn't a
good idea but I don't have any solid evidence to back that up. I know
that I CAN do it but do people actually do it?
How is performance? I'm working with a vendor that is recommending this
scenario for their product.
Thanks for any advice.
Toni
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!It depends. You need to determine whether your server will be able to
handle the additional load.
"Toni" <teibner@.allina.com> wrote in message
news:#XyGcoLnDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Is it a good idea to install multiple instances of SQL Server one one
> server in a production environment? I've always heard that it isn't a
> good idea but I don't have any solid evidence to back that up. I know
> that I CAN do it but do people actually do it?
> How is performance? I'm working with a vendor that is recommending this
> scenario for their product.
> Thanks for any advice.
> Toni
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Toni,
It depends on how much activity your production server has, how powerful a
machine it is on, and so forth. However, for keeping the pulse on the
overall tuning of the server, I don't do this with production.
(But in the Dev/QA world we are doing it more and more.)
Here is part of a thread where Hal Berenson discussed multiple instances:
http://tinyurl.com/sk7o
Russell Fields
"Toni" <teibner@.allina.com> wrote in message
news:%23XyGcoLnDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Is it a good idea to install multiple instances of SQL Server one one
> server in a production environment? I've always heard that it isn't a
> good idea but I don't have any solid evidence to back that up. I know
> that I CAN do it but do people actually do it?
> How is performance? I'm working with a vendor that is recommending this
> scenario for their product.
> Thanks for any advice.
> Toni
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||My experience is that: Avoid it if you can! Do it if you must!
Having said that, we use multiple instances in production all the time,
primarily to accommodate different collations. It's no fun to have multiple
collations inside an instance.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Toni" <teibner@.allina.com> wrote in message
news:%23XyGcoLnDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Is it a good idea to install multiple instances of SQL Server one one
> server in a production environment? I've always heard that it isn't a
> good idea but I don't have any solid evidence to back that up. I know
> that I CAN do it but do people actually do it?
> How is performance? I'm working with a vendor that is recommending this
> scenario for their product.
> Thanks for any advice.
> Toni
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!