Sounds like you're dealing with Interland!
I feel your pain. I had to deal with a situation like that. Even over a
T1, it took several minutes. It would be no big deal if you were able to
see only your own database. I'd do it for my clients if I knew how to do
that.
So long as the disks are fast and there's TONS of memory (like over 1GB) on
the server, then I think a SQL server could probably handle a hundred
databases - no problem. But 600 is REALLY pushing the limits. I wouldn't
even put that many websites on a single box!
I think if you keep it below 50 db's, you'll be just fine. But on the other
hand, if any of those db's are creating extreme traffic, it will affect all
the others. It only takes one bad programmer to screw it up for everyone on
the whole server.
---mark
------------------------------------
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
====================================
> -----Original Message-----
> From: Steve Cohen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 22, 2001 10:29 AM
> To: CF-Community
> Subject: SQL Server: How many is too many?
>
>
>
> I am currently dealing with a hosting company that offer SQL
> server. After
> waiting at least 20 minutes to connect to their SQL Server through
> Enterprise Manager, I saw that they had 606 databases. Seems to
> me that is
> an overload. I would like to know what other people's
> experiences are with
> SQL Server in terms of number of databases. What is the recommended norm
> before it is consider an overload?
>
> Thanks,
> Steve
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
