Re: Maximum practical number of databases per SQL Server 2000 Instance
From: Bob Castleman (nomail_at_here)
Date: 12/15/04
- Next message: Bart Duncan [MSFT]: "Re: What all could be the security issues in Unicode Database"
- Previous message: Mike W: "Inserting/Updating and locking"
- In reply to: Cesar: "Maximum practical number of databases per SQL Server 2000 Instance"
- Next in thread: Mike Epprecht \(SQL MVP\): "Re: Maximum practical number of databases per SQL Server 2000 Instance"
- Reply: Mike Epprecht \(SQL MVP\): "Re: Maximum practical number of databases per SQL Server 2000 Instance"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Dec 2004 16:23:13 -0500
We have hundreds of databases on our cluster. It creates some interesting
issue (starting and stopping the service takes a looooong time, for
example). But it runs pretty smoothly, all things considered.
Bob Castleman
SuccessWare Software
"Cesar" <Cesar@discussions.microsoft.com> wrote in message
news:1FCBB476-FEC0-493C-AA99-D7BF6E867B84@microsoft.com...
> Does anyone know what the maximum practical number of databases that could
> be
> created and used per a SQL Server 2000 Enterprise Instance. I know that
> the
> theoretical limit in BooksOnLine is 32K. But my application is dying way
> before that.
>
> Thanks in advance
>
> Cesar
- Next message: Bart Duncan [MSFT]: "Re: What all could be the security issues in Unicode Database"
- Previous message: Mike W: "Inserting/Updating and locking"
- In reply to: Cesar: "Maximum practical number of databases per SQL Server 2000 Instance"
- Next in thread: Mike Epprecht \(SQL MVP\): "Re: Maximum practical number of databases per SQL Server 2000 Instance"
- Reply: Mike Epprecht \(SQL MVP\): "Re: Maximum practical number of databases per SQL Server 2000 Instance"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|