Limits on Number of database...

I have created "around 25 excluding system databases" number of databases in
one SQL server instance. Is there any limits on number of SQL server
databases which affects the performance of SQL Server.
I am using SQL 2K.
Thanks,
Akshay
"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>I have created "around 25 excluding system databases" number of databases
>in
> one SQL server instance. Is there any limits on number of SQL server
> databases which affects the performance of SQL Server.
> I am using SQL 2K.
> Thanks,
> Akshay
>
It depends..
How heavily is each database used?
How big is your system (processors, memory etc.).
It's not really the number of databases that is an issue, but rather how
they are being used. One thing to note however is that with a lot of
databases, it may take longer for the SQL Server to come back online as it
does some work with each database when the system is restarted.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Also keep in mind that the SQLServer:Database performance counters are only
collected on the first 99 databses.
Sincerely,
Anthony Thomas

"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:e1aaZ3VCFHA.868@.TK2MSFTNGP10.phx.gbl...
Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>