Server Capacity Planning

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Server Capacity Planning

Server Capacity Planning

Rate Topic

Display Mode

Topic Options

Author

Message

Mohan Kumar VS

Posted Tuesday, March 02, 2010 7:21 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 10:13 PM
Points: 283, Visits: 311

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

naga.rohitkumar

Posted Friday, August 24, 2012 4:49 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:34 AM
Points: 525, Visits: 997

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

PaulB-TheOneAndOnly

Posted Friday, August 24, 2012 5:42 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:03 AM
Points: 2,979, Visits: 4,389

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

Mohan Kumar VS

Posted Friday, August 24, 2012 5:57 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 10:13 PM
Points: 283, Visits: 311

Hi Rohit

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

Regards
Mohan Kumar VS

Post #1349599

Mohan Kumar VS

Posted Friday, August 24, 2012 5:59 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 10:13 PM
Points: 283, Visits: 311

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

Steve Jones - SSC Editor

Posted Friday, August 24, 2012 7:54 AM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

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 »

Permissions