September 18, 2015 at 11:17 pm
Hi
We changed datacenter. in New datacenter we use new servers with better hardware performance (as our server team says).
But I see an strange issue : Increase Backup time.
I backed up from main database database in 3 minute. and in new server in 12 minute and some times in 30 minutes !!!!!
I Restored this database in 4 minutes and now in 10 minutes. ????
this problem happened in another databases but not much.
For example : a 1 minute back up time changed to 5 minute and ...
I am afraid.
Please help me about this.
thank you
September 19, 2015 at 3:54 am
Is it just Backups? if so could it be that the backups used to be compressed but are not now? Compressed backups need a lot less I/O (both during Backup and Restore)
September 19, 2015 at 11:20 am
Backup times are mostly from IO. If your backups have slowed down and the sizes haven't increased, then it's likely that the IO throughput on the IO subsystem has decreased. Ask the server team to produce exact latency and throughput metrics during the backup times.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2015 at 7:41 am
And you can check the wait statistics yourself to see why the backups are taking time. Query sys.dm_os_wait_stats before and after the backup. See what the issue is there.
"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
September 25, 2015 at 9:06 pm
Thank you All
I checked it with server team.
Most likely It's related to new backup server . It has a drive with 2 T.byte size.
Although they say it was supported but we have some problems with this size.
And when I want to backup to this drive , I encounter a big delay as I said.
Then We should seprate this size to two drive . I'll say to you the result.
September 26, 2015 at 7:32 am
MotivateMan1394 (9/25/2015)
Thank you AllI checked it with server team.
Most likely It's related to new backup server . It has a drive with 2 T.byte size.
Although they say it was supported but we have some problems with this size.
And when I want to backup to this drive , I encounter a big delay as I said.
Then We should seprate this size to two drive . I'll say to you the result.
The size of the backup volume is simply the amount of data the drive can hold.
The type and throughput of the backup volume is what you need to look at. If, for example, your previous backup was to a SAN and your current backup is being written to a local drive, your backup times are going to be different because of the hardware involved.
In my case, when we moved from one SAN to another (newer) SAN for the backups, the time dropped significantly. I'm talking it took about half the time after we switched to the newer SAN. The data and log files didn't move; only the backup destination. It can make a real difference.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply