question

Mohan Kumar avatar image
Mohan Kumar asked

Server Capacity Planning

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

sql-server-2005capacity-planning
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3,200 concurrent users is HUGE! Can you tell us a little bit about your application and what they will be doing once they have connected?
1 Like 1 ·
Matt Whitfield avatar image
Matt Whitfield answered

This is a totally unanswerable question.

I can support 3200 concurrent users for an application that sends them a message that says 'Hello world' on my desktop PC.

So you really need to say a little bit about what your application does.

And yes, SQL Server won't have a problem with that many concurrent users, but you'll need to be running on some pretty significant hardware. It's not just about RAM, you need to consider disks and what your SAN fabric will look like, networking, redundancy, etc. Plus you will want to consider having separate application and database servers.

But without saying anything about what your application is, what the data size is, how many interactions with the database each user will make etc, it's absolutely impossible to give you any meaningful information.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the response. Ours is a health care product. There will be 3200 concurrent users. The data size will be almost 1 TB. There will be simple operations like inserting / updating & querying. Also the application has messaging features (Broker Service). Rgds Mohan Kumar
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered

The other question I'd ask is do they mean 3200 simultaneous connections performing active transactions, or simply 3200 users in the system. The difference between those two is pretty massive. I supoort a system with over 5000 users, but the active connection load is usually 3-7 with spikes up to 15.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the response. Ours is a health care product. There will be 3200 concurrent users. The data size will be almost 1 TB. There will be simple operations like inserting / updating & querying. Also the application has messaging features (Broker Service). Rgds Mohan Kumar
0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered

We would like to see a few questions answered so we can make better suggestions.

  • Are these users accessing SQL simultaneously?
  • What response times are expected?
  • Are you on a SAN? ... or DASD? And what throughput are you getting from the disk subsystem?
  • Is this an internal application or Internet-facing?
  • What are the sizes of your largest tables?
  • What are the sizes of your most heavily utilized indexes?
  • Do you have any baseline metrics for the current application or is this all theoretical?
  • Will you be running in 64 bit?
  • Will replication be involved?
  • What size rows are being inserted?
  • Is there BLOB data involved?
  • ...
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.