March 12, 2015 at 1:07 am
We have daily full backup scheduled at 8.30 AM. We are getting Timeout expired when
we try to access a web page using the database being backed up.
The web page has several select and few update/insert statements
Does backup effect this? How to identify and fix this issue?
Thanks
KRS
March 12, 2015 at 4:31 am
Backup adds load to the server, but it doesn't lock things and cause blocking. The added load could be causing the timeouts, but it's hard to say without more information. I'd capture the wait statistics before and after your backup (or use extended events to capture them on the fly) in order to understand why it's running slow, if it is. I'd do the same with your queries. Also, I'd monitor for blocking (extended events again) in order to see why you're getting timeouts. Also, look to the wait statistics for your queries to understand why they're running slow.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 18, 2015 at 4:44 am
Yes, I understand that backups will not lock. I need more information on how to troubleshoot this and eventually fix the issue.
March 18, 2015 at 7:10 am
Like I said, capture the wait statistics that occur during the process. That will tell you what's running slow. You'll have to figure out why.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply