Huge Traffic for 24 Hours

Last Post 24 Jun 2007 01:03 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
SQLUSA
New Member
New Member

--
24 Jun 2007 06:39 AM
For a 24 hour period (exception 2-6am EST) overwhelming traffic is expected. Some visitor will do minimal registration (like email), other become subscribers to magazines with full address registration and cc payment capture. Total visitors in the order of 1-2 million (some will leave landing page without doing anything).
Platform: SQL 2000 SP4, 4CPU, 8GB, TranLog on C: RAID1, Data on D: RAID5, tempdb on E: RAID1
Indexes rebuilt 4-5am. Log shipping running 7am to 2am.

Clearance is given to DBA to kill any blocking process, to disable any scheduled job, to stop any normal activity which can be in the way of servicing the surge. DBA can even rename a large populated table and replace it with an empty one to keep the system rolling.

What measures do you suggest to keep the system humming which was not designed for such a surge?

Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com
SQLUSA
New Member
New Member

--
24 Jun 2007 01:03 PM
Thanks rm.

>Distribute transaction to multiple tables with same schema to reduce blocking,

I see the value of this, requires software change...

>add more disk arrays for db data files to reduce disk contention.

Not feasible for 1st surge. Possibility for subsequent surges.


Kalman Toth, Database Architect
SQL Sever 2005 Training - http://www.sqlusa.com/bestpractices2005


Acceptable Use Policy
---