Database Should Support 25000 Concurrent Users ?

Question

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.

Manikavelu Velayutham · Answer

Yes I already read the forum. 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 Nair · Answer

select @@MAX_CONNECTIONS ==> 32767 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 Velayutham · Answer

SQL SERVER 2008

Suthish Nair · Answer

Mani Which Database SQL server version using.