MSDE multiple instances

Hello there,
I want to install multiple instances of MSDE on XP prof edition. How many
instances can i create on a single machine?
Also, any URL for this would be helpful?
Thanks,
David
hi David,
David wrote:
> Hello there,
> I want to install multiple instances of MSDE on XP prof edition. How
> many instances can i create on a single machine?
> Also, any URL for this would be helpful?
> Thanks,
> David
you can install up to 16 instances per server, but this is a theorical limit
as you will not have enought resources to serve all of them..
each additional running instance will add about 20mb of RAM requirement but
this only is the initial load, as the real load will depend on instance
activity that will end up at the Win32 process limit of addressing up to 2gb
of RAM, and many running instances will of course bring your server down to
knees...
for additional information about SQL Server memory management, please have a
look at excellent Ken Henderson's article at
http://msdn.microsoft.com/library/de...v_03252004.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply