May 8, 2018 at 6:34 pm
my normal full back up use to take 30 min and one day suddenly it jumped to 5 hours.
how can i figure out what is happening to sql serverbackups
May 9, 2018 at 1:12 am
mandavli - Tuesday, May 8, 2018 6:34 PMmy normal full back up use to take 30 min and one day suddenly it jumped to 5 hours.
how can i figure out what is happening to sql serverbackups
Has the database grown considerably?
Is there anything else running at the same time as your backups?
Thanks
May 9, 2018 at 2:05 am
Has the underlying storage changed? Is your storage experiencing other problems?
Are you backing up locally or remotely? If to a remote location, has your network config changed?
Were you backing up compressed, and now uncompressed?
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 9, 2018 at 4:31 am
Capture the wait statistics during the backups to understand what your server is waiting on. That can very quickly narrow down what's going on. However, everyone has already pointed out the key question. What changed?
"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
May 9, 2018 at 6:29 am
nothing has changed as far as I know, and it's always been uncompressed and local backup
how do I get wait status statistics?
May 9, 2018 at 8:16 am
mandavli - Wednesday, May 9, 2018 6:29 AMnothing has changed as far as I know, and it's always been uncompressed and local backup
how do I get wait status statistics?
Here's one example from Paul Randal. Here's an example from my blog. There are others if you look around. Extended Events are the way to get this done.
Something changed. I'd focus on what.
"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
May 9, 2018 at 9:19 am
Have you recently patched the server?
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply