Maximum # of databases on 1 sql server

Does any one know the reccomended maximum number of
databases that can be supported on on SQL install. Is
their a recommended maximum to insure that performance in
not degraded.
Thanks32,767 PER INSTANCE OF SQL SERVER. Different Edtion of SQL Server Support
different max. number of instances on SQL machine.
"John" <jtscott@.mclanefs.com> wrote in message
news:05a801c3929f$8a76e950$a301280a@.phx.gbl...
> Does any one know the reccomended maximum number of
> databases that can be supported on on SQL install. Is
> their a recommended maximum to insure that performance in
> not degraded.
> Thanks|||We have servers with up to 150 databases, which represents over 100
applications. It's all about reducing interference (ie, keeping
transactions small, no !#!##%$ cursors, etc), and managing hardware
capacity. Go big on the hardware, if you're saving $$ from sharing, it's
worth it, do not run at > 40% peak.
"John" <jtscott@.mclanefs.com> wrote in message
news:05a801c3929f$8a76e950$a301280a@.phx.gbl...
> Does any one know the reccomended maximum number of
> databases that can be supported on on SQL install. Is
> their a recommended maximum to insure that performance in
> not degraded.
> Thanks|||In addition:
Go above some 50-70 databases and you will notice that the tools (EM...) aren't that well suited.
And, a large amount of databases can be a sign of bad design. (Doesn't have to be, but can be.)
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Kevin" <ReplyTo@.Newsgroups.only> wrote in message news:OfUQGNskDHA.424@.TK2MSFTNGP10.phx.gbl...
> We have servers with up to 150 databases, which represents over 100
> applications. It's all about reducing interference (ie, keeping
> transactions small, no !#!##%$ cursors, etc), and managing hardware
> capacity. Go big on the hardware, if you're saving $$ from sharing, it's
> worth it, do not run at > 40% peak.
>
> "John" <jtscott@.mclanefs.com> wrote in message
> news:05a801c3929f$8a76e950$a301280a@.phx.gbl...
> > Does any one know the reccomended maximum number of
> > databases that can be supported on on SQL install. Is
> > their a recommended maximum to insure that performance in
> > not degraded.
> >
> > Thanks
>