max number of databases

From: NAN (anonymous_at_discussions.microsoft.com)
Date: 08/11/04


Date: Wed, 11 Aug 2004 15:28:17 -0700

I realize it all has to do with how much ram, disk space,
cpu, etc.. but is there a maximum number of databases you
should have on 1 database server? Here are some specs:
2cpu's @1ghz
2 gb ram
plenty of disk space
clustered
The problem is that mgmt keeps putting more and more db's
on this server (there are over 60). Every day the error
log has to be deleted because it is too large to open.
Mgmt now wants reasons why NOT to put any more db's on
this server. They are koo koo.
Thanks.



Relevant Pages

  • Slow server response - Plese help!
    ... I physically have 16 GIG of ram installed in one of them. ... It is running exchange and sharepoint services. ... Exchange and a Data Server. ... If I look in the perfmon on the Terminal Server, I see about 8 SQL databases ...
    (microsoft.public.backoffice.smallbiz)
  • Re: Type of Cluster?
    ... in the ideal situation you limit the RAM used by ... > I was thinking of placing the databases in Windows 2003 Cluster. ... > that each server in the cluster will maintain its own database. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Slow server response - Plese help!
    ... Pull the extra ram, adjust the pagefile if necessary and see if things ... With the amount of Ram in my server wouldn't the system properties ... It is running exchange and sharepoint services. ... I also have about two or three MSDE databases running on the exchange ...
    (microsoft.public.backoffice.smallbiz)
  • Re: 64bit CPUs
    ... > A somewhat obvious question to some perhaps, but what server application ... Databases. ... running processes which would like to use more than 2GB of RAM. ... Apart from larger RAM, ...
    (freebsd-performance)
  • Squid sizing ?
    ... I want to use Squid to server for a network that has about 500 users. ... How many RAM and disk space should I have? ...
    (SunManagers)