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

High Traffic Website Design Expand / Collapse
Author
Message
Posted Friday, January 28, 2011 4:54 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, January 31, 2013 4:02 PM
Points: 69, Visits: 539
Hi All,

I need some advice/suggestions on a situation.

Currently we have one instance of SQL Server R2 running on Windows Server 2008 R2 on 12.0 GB of RAM and 24 (2.93 GHz) processors.
Most of the databases have Identity column as the primary key. Lot of the internal applications are tied to this Identity column. We are currently at 10 million rows on the identity column in the table having maximum number of rows.

We are expecting a lot of website traffic in near future. I would say to be on the safer side and as a test case approximately around 20000 users an hour would be present on the website. They would be inserting records into 15 tables concurrently.

How can I increase the scalability of this so that users are served without any interruption ?

Thanks,
Suri
Post #1055685
Posted Friday, January 28, 2011 6:01 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 7:12 AM
Points: 31,284, Visits: 15,746
Short answer is add more hardware.

You haven't given anywhere near enough information to take a guess, and this isn't something that will be answered in a forum.

Are there bottlenecks? How does the hardware perform? The application? 20,000 users an hour doesn't mean anything. Do they read rows? Do they all insert 1 row? 10 rows? multiple tables? Identities go up to 2B rows, so 10mm isn't a lot.

If you are worried about scale, engage a consultant. I can recommend someone if I know where you are.







Follow me on Twitter: @way0utwest

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

Add to briefcase

Permissions Expand / Collapse