Alexander Osorio wrote:
> Thats!, I need 1 instance of SQL Server, then how many databases can
> hold 1 instance?, I have unlimited hard disk space and 1 GB Ram
> Thanks!

> hi,
> Alexander Osorio wrote:
>> Thats!, I need 1 instance of SQL Server, then how many databases can
>> hold 1 instance?, I have unlimited hard disk space and 1 GB Ram
>> Thanks!
> technically it should be 32767, the upper limit of a 16bit integer.. but
> such a number I do think is not "usable" by a human being...
> 1gb of ram is not very much if the instance is heavy loaded, both in term
> of database's size and traffic...
> traffic will be of course be previously trapped by the built in Query
> Governor Workload (only in MSDE 2000), that will kick in when more the 8
> concurrent workloads (or batches) are running, slowing down all executing
> runs...
> if you add "differential" databases usage that will imply a lot of
> contention for memory on SQL Server related memory ... every "query" will
> try to load datapages into memory, obviously discarding older ones (it's
> not that simple the algorithm used by SQL Server thought), as compiled
> query plans use memory as well, and so do "connection objects" and so
> on...
> of course, 1 gb of ram can be enought for "traditional" niches where MSDE
> has been used since it's introduction... with "moderated" traffic and the
> like...
> what is you problem?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> --------- remove DMO to reply
>

Alexander Osorio wrote:
> Hi Andrea,
> I have 1 customer with 5 users, but they brings accounting General
> ledger to companies crashes (until their extinction), are 600
> companies, they operates only 5 or 6 at same times, rest are waiting,
> actually they uses access mdb's (600 mdb's), but too much
> corruptions.

>Its possible have 600 db's in Sql Server (MSDE)?, i`ll
> have delay in loading the engine at first time?

>, only 5 o 6 db's will
> be in use at same time