RE: multiple instances system requirement

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 02:36:08 -0800

Chia,

It depends on what you are gonig to put into each instance. You need to capacity plan and size every database on every instance, and then estimate the growth for each database. Always over-guess to make room for the future. Having 4 instances on one box seems quite a lot to me, and sounds like you would need at least a 4-processor box - however a single or dual box might be fine - depends on usage.

Sorry for the vague answer - this situation requires lots of planning and testing. 

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk

Relevant Pages

  • Re: Albums you plan to buy next...
    ... My definitions of 'planning' and 'next' are pretty vague, ... (A moment of silence for the days when I ... D-Sisive: Let The Children Die ...
    (rec.music.hip-hop)
  • Re: find out a user/account permission...
    ... The attached query should work for you, it is based around sysprotects. ... Mark Allison, SQL Server MVP ... "Steve Lin" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Can i start a MSSQLServer service remotely?
    ... Administrative Tools-->Computer Management, then expand Services. ... Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Protecting database from administrators
    ... Regular users of the database can be secured by only allowing them access through an application, using stored procs, etc.. ... Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Last payment is also a bigger payment
    ... Your "specification" is too vague for anyone to give you much help. ... an accurate and useful response. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
Quantcast