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