March 5, 2013 at 4:46 am
Hi All
I migrated the old server to a new server of which it’s a VM. Now the backups taking long but other sql processes have improved 90% in performance but the backups seems degrading. Had a word with infrastructure guys and storage seem not to agree. Performance from the front end tool is great BI is happy but i'm not the happy one with backups performance. Please advice if i missed something.
New Server
VM Hosted server storage configuration SAN
SQL Svr 2005 Ent 32bit SP4 (Upgraded the SP2 to SP4)
Windows Ent 2008 R2 64bit SP1
16GB RAM
Intel(R) Xeon(R) CPU E7- 2870 @ 2.40GHz
Physical CPU count 8
AWE enabled
LIPM sql service account added
Max Server memory 14GB
Backups to the local drive with HyperBac took 3hrs 50min to complete
-------------------------------------------------------------------------------------
Old Server
SQL Svr 2005 Ent 32bit SP2
Windows Ent 2003 32bit SP1
8GB RAM
Intel(R) Xeon(R) CPU 5160 @ 3.00GHz
Physical CPU count 4
LIPM sql service account added
AWE enabled
Max Server memory 6GB
Backups to the local drive with HyperBac took 1hr 18min to complete
It's better to fail while trying, rather than fail without trying!!!
March 5, 2013 at 5:19 am
Backups are pretty much an IO bound operation. Check the latency and throughput on the drives.
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
March 5, 2013 at 5:54 am
Thx Gila, awaiting storage team as the backup is running before the ETL. Will advise on their findings
It's better to fail while trying, rather than fail without trying!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply