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.
Microsoft SQL Server

Avatar of undefined
Last Comment
DBAduck - Ben Miller

8/22/2022 - Mon
DBAduck - Ben Miller

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.