Is there a Microsoft recommendation for how many databases that can exist on a SQL Server 2000 (std ed) server (Windows 2000 4 CPU, 4GB RAM)? What formulas/calculations can be made to determine the capacity (# of db's w/o affecting performance/resources) for a given server?It's not so much the number of databases that matter as much as their usage.
We have a 2 CPU box with 2 Gb of RAM that has 107 databases on it and works
great. We also have a 4CPU box with 8Gb of RAM with 67 databases on it that
works fine. We then have a 4CPU cluster with 4 Gb of RAM that has only 3
databases, the application runs fine but our database box is about maxed
out.
Basically other than disk space, a database won't consume SQL Server
resources unless it's actually used. So apart from the fixed limitation of
32,767 databases per instance there is no concern about the number of
databases. It's all about their utilization.
"LAM" <anonymous@.discussions.microsoft.com> wrote in message
news:2F6DFF19-F6B1-446A-85FA-0BDA53230CF1@.microsoft.com...
> Is there a Microsoft recommendation for how many databases that can exist
on a SQL Server 2000 (std ed) server (Windows 2000 4 CPU, 4GB RAM)? What
formulas/calculations can be made to determine the capacity (# of db's w/o
affecting performance/resources) for a given server?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment