Link to home
Start Free TrialLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

SQL Server back ups during high volume event

if I am experiencing high web traffic during a four-hour event, would it help my sql server db processing if I pause my backups during that event?

We are timing a very large high school cross-country meet in a somewhat remote location tomorrow and I want to do everything I can to get results online in near-real time without transaction locks because too many folks are hitting the server looking for results.
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial