InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 21:32:21 GMT20http://www.sqlservercentral.com/Forums/Topic875138-146-1.aspxKeep 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.Fri, 24 Aug 2012 07:54:10 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic875138-146-1.aspxHi PaulThank 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.RegardsMohan Kumar VSFri, 24 Aug 2012 05:59:19 GMTMohan Kumar VShttp://www.sqlservercentral.com/Forums/Topic875138-146-1.aspxHi RohitThank you very much. I had left that organization & I'm working else where now... RegardsMohan Kumar VSFri, 24 Aug 2012 05:57:18 GMTMohan Kumar VShttp://www.sqlservercentral.com/Forums/Topic875138-146-1.aspx[quote][b]Mohan Kumar VS (3/2/2010)[/b][hr]Our application will be used by 3200 concurrent users in the near future. [/quote]I'm in agreement with Rohit. Chances are the base statement for capacity planning is tainted - hard to believe an application handling 3200 [b]concurrent [/b]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?-- ...Fri, 24 Aug 2012 05:42:59 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic875138-146-1.aspxHI,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 tempdb4. 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 ram6. depending on the first point i said " you calculate as per ur requirement " Thanks RohitFri, 24 Aug 2012 04:49:32 GMTnaga.rohitkumarhttp://www.sqlservercentral.com/Forums/Topic875138-146-1.aspxHiOur 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.RgdsMohan Kumar VSTue, 02 Mar 2010 07:21:47 GMTMohan Kumar VS