Multiple databases

Which is better..
Multiple databases on a single instance of SQL
OR
Multiple instances of Sql server, for multiple databases?I prefer multiple databases unless I have a reason to go multiple instances.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sql" <sql@.discussions.microsoft.com> wrote in message
news:78A84D8C-C8DD-4AC1-BDEA-A54332CDB8D1@.microsoft.com...
> Which is better..
> Multiple databases on a single instance of SQL
> OR
> Multiple instances of Sql server, for multiple databases?|||sql,
Multiple instances consumes much, much more resources. I rarely use
multi-instance SQL Servers except for dev and test environments.
Definitely go for multi-database.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
sql wrote:
> Which is better..
> Multiple databases on a single instance of SQL
> OR
> Multiple instances of Sql server, for multiple databases?|||Instances provide better isolation from a security and environment
perspective. I've isolated the HR and accounting environments to their own
instances for this reason. We also have third party on a different instance
from standard production. Othe than that, the mainline production
(in-house) systems are all on one production instance.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u2VtYs3uEHA.1616@.TK2MSFTNGP10.phx.gbl...
> sql,
> Multiple instances consumes much, much more resources. I rarely use
> multi-instance SQL Servers except for dev and test environments.
> Definitely go for multi-database.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> sql wrote:
> > Which is better..
> >
> > Multiple databases on a single instance of SQL
> > OR
> > Multiple instances of Sql server, for multiple databases?