In my application, database supports around 5000 concurrent users at a time. At this stage cpu usage is around 33%.
Now there is a requirement that our database should supports 25000 concurrent users at a time.
What are all the steps I need to take to fulfill the above requirements.
Loading
Manikavelu VelayuthamPosted Nov 12, 2010, 6:24 AM
But my question is for 5000 users itself, cpu utilization gone upto 33%. So just imagine, if the users are increased upto 25000 users, surely cpu utilization will be 100% and the system will get hanged.
To avoid that situation what are all the optimization I need to do.
Do I need to Scale Up or Scale Out my database to support 25000 Users.
If its scale up --> What are all the things to be considered ?
If its scale out --> What are all the things to be considered ?
Suthish NairPosted Nov 12, 2010, 6:04 AM
Its showing 32767 as max connections, in your case its 25000.
So might there not need any settings.
Also, this msdn forum saying there is no limitations for concurrent users.
Manikavelu VelayuthamPosted Nov 12, 2010, 2:44 AM
Suthish NairPosted Nov 12, 2010, 2:43 AM
Which Database SQL server version using.