Database performance during Azure Full Backup #915
Unanswered
cblaze22
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I've been using the script for years. Recently, however, we're experiencing site performance issues during the early morning hours. The problem appears to start at 3:00 AM, which coincides with our full database backup using a maintenance script on an 87GB database. We also run an Azure backup at 4:00 AM. It seems the database struggles to respond quickly, causing the site to load very slowly and backup incoming requests.
Below is our command. Could this be causing the database to have difficulty returning queries promptly?
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d Maintenance -Q "EXECUTE [dbo].[DatabaseBackup] @databases = 'DB1,DB2,DB3', @url = N'https://path/exposure', @BackupType = 'FULL', @compress = 'Y', @Blocksize=65536, @MaxTransferSize=4194304, @filename='{ServerName}${InstanceName}{DatabaseName}{BackupType}{Partial}{CopyOnly}.{FileExtension}', @init='Y', @Format='Y', @LogToTable = 'Y'" -b
We disabled the backup through the agent and haven't had issues for two months now. Is this an issue that could specifically be tied to Azure only?
Beta Was this translation helpful? Give feedback.
All reactions