Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Server Capacity Planning Expand / Collapse
Author
Message
Posted Tuesday, March 2, 2010 7:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 1, 2013 2:51 AM
Points: 283, Visits: 312
Hi

Our application will be used by 3200 concurrent users in the near future.

1. Can you please let me know the minimum Hardware requirements (Especially RAM)?
2. Will Sql Server 2005 (Standard Edition) be able to handle 3200 concurrent users?

Kindly suggest ASAP.

Rgds
Mohan Kumar VS
Post #875138
Posted Friday, August 24, 2012 4:49 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
HI,
please excuse if any wrong suggestions


In my environment in[banking domain ] which my application is running with [.net and sql server 2005 ]
1. in my deep monitoring from 9 months i have seen maximum of 420 concurrnet users in the job activity monitor.

2. due to the most hits from the concurrent users " tempdb " issues happend so many times later we increased more space to tempdb (files ) containing drive .

3. in this mean while before increasing space i workedout as per microsoft recommendations 16 processors should run in 24 gb ram but in my environment it is runig in 2gb instead of increasing the ram sapce is allocated for tempdb

4. to solve the rapid growth of tempdb in most concurrent users

5. i have link sorry to say this activity happend before 6 months but iam unable to find that mail once i found i'vl send by that u can see the process to check details of processors using ram

6. depending on the first point i said " you calculate as per ur requirement "

Thanks
Rohit


Thanks & Regards
NAGA.ROHITKUMAR
Post #1349578
Posted Friday, August 24, 2012 5:42 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
Mohan Kumar VS (3/2/2010)
Our application will be used by 3200 concurrent users in the near future.


I'm in agreement with Rohit. Chances are the base statement for capacity planning is tainted - hard to believe an application handling 3200 concurrent users is managed as lightly as this one appears to be.

Please confirm concurrency, also...
-- how about data volume?
-- insert/update/delete activity?
-- usage, is this OLTP or DSS?
-- requirements for replication?
-- requirements for business continuity a.k.a. DR planning?
-- external dependencies?
-- ...


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1349595
Posted Friday, August 24, 2012 5:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 1, 2013 2:51 AM
Points: 283, Visits: 312
Hi Rohit

Thank you very much. I had left that organization & I'm working else where now...

Regards
Mohan Kumar VS
Post #1349599
Posted Friday, August 24, 2012 5:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 1, 2013 2:51 AM
Points: 283, Visits: 312
Hi Paul

Thank you very much for your response. The requirement was for a government project and the details were provided by the IT team over there. Right now I'm not working with that organization. Thanks again.

Regards
Mohan Kumar VS
Post #1349603
Posted Friday, August 24, 2012 7:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 33,088, Visits: 15,197
Keep in mind that 3200 people connecting to your application (web or thick client), don't mean 3200 connections to SQL Server. Usually those connections come and go.

However user connections don't give you any idea for load unless you know what they're doing. One user can fill tempdb or use up all the memory.

What you need to do is profile the application, and get an idea of the load from different use cases. Then scale those up. SQL Server 2005 can definitely handle large loads, though I'm not sure why you wouldn't at least use 2008 R2 if not 2012.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1349679
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse