Server Capacity Planning

Question

question

Mohan Kumar asked Mar 2, '10

Server Capacity Planning

Hi

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

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

Kindly suggest ASAP.

Rgds Mohan Kumar VS

sql-server-2005 capacity-planning

1

10 |1200

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

Ian Roke commented · Mar 02, 2010 at 11:23 AM

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 ·

Answer 1 · 2010-03-02T11:30:23Z

Matt Whitfield answered Mar 2, '10

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

10 |1200

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

Mohan Kumar commented · Mar 03, 2010 at 02:53 AM

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 ·

Answer 2 · 2010-03-02T12:12:28Z

Grant Fritchey answered Mar 2, '10

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

10 |1200

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

Mohan Kumar commented · Mar 03, 2010 at 02:53 AM

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 ·

Answer 3 · 2010-03-07T10:19:59Z

Blackhawk-17 answered Mar 7, '10

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

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

question