Re: Multiple databases

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 17:44:41 +0100

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?

Relevant Pages

  • Re: Running multiple instances in production environment. Good or bad?
    ... > Wayne Snyder, MCDBA, SQL Server MVP ... > that login sysadmin role membership... ... >> to be negative to running multiple instances in a production ... > There are several reasons why most of us would TRY very hard NOT to have ...
    (microsoft.public.sqlserver.server)
  • Re: Additional instances and licensing...
    ... "A Microsoft SQL Server 2005 Enterprise Edition license entitles you to install multiple instances of SQL Server 2005 Analysis Services on a single computer. ...
    (microsoft.public.sqlserver.setup)
  • Re: 3 queries about active/active and multi-instance
    ... To run multiple instances of SQL Server in the same machine. ... machines are servicing the same database. ... Multiple instance cluster is more ...
    (microsoft.public.sqlserver.clustering)
  • Re: Running multiple instances in production environment. Good or bad?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > to be negative to running multiple instances in a production ... There are several reasons why most of us would TRY very hard NOT to have ...
    (microsoft.public.sqlserver.server)
  • Re: Multiple databases
    ... I prefer multiple databases unless I have a reason to go multiple instances. ... Tibor Karaszi, SQL Server MVP ... > Multiple instances of Sql server, ...
    (microsoft.public.sqlserver.server)