Scaling up

Question

Scaling up

potucekj

Default port

Points: 1414
More actions
August 10, 2004 at 8:18 am

#83465

In order to reduce the number of SQL Server Instances in our Network, my Company is considering combining our current Environment (30 - 40 Prod and DEV Instances with MULTIPLE Databases and a diverse set of Applications) into 2 Production Clusters and DEV/TEST Instances as needed. We will probably also add several more LARGE applications to replace our current CRM environment.
In talking with some of the developers and business people there could be as many as 1000 users accessing any one SQL Server database at any time.
I need to research this and find out what kind of limitations or guidelines on SQL*Server such as maximum file size for database files, number of users or memory restrictions.
I also need information on how these Clusters need to be configured to handle that kind of usage.
Can anyone lend any insight or perhaps tell me where I may be able to research this?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Carl B. SSCertifiable Points: 7931 More actions · Answer 1

Hello,

you can take a look in BOL (books online). Search for the document named : Maximum Capacity Specifications. You will have some answers there.

But for Cluster configuration I am a newby . Maybe someone else can help you on that one.

Hope it will help.

Carl

sa24 SSCrazy Eights Points: 8027 More actions · Answer 2

You can go for Active/Active clustering. But something you need to be aware about is that Active/Active Clustering will not be helpful to balance the load. To balance the load, you can probably think about using replication with load balancing.

Memory restrictions depends on the OS you would be installin on your server. 2000 DataCenter supports upto 64 GB memory. I don't think of any limit to no. of concurrent users but you will have to scale your hardware accordingly. i.e. more no. of CPU's.

Personally, i don't think it might be a good idea in putting all your appications on one server. You can get the fastest hardware but if it goes down, you are risking all your applications to be down. Just a thought.

potucekj Default port Points: 1414 More actions · Answer 3

Thank you for the thoughts.. And I agree about NOT putting all your eggs in one basket.. but I can only make recomendations.. not the final decisions.