Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance Issues when backing up BI db's Expand / Collapse
Author
Message
Posted Tuesday, March 05, 2013 4:46 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 6:13 AM
Points: 925, Visits: 861
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!!!
Post #1426752
Posted Tuesday, March 05, 2013 5:19 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:22 AM
Points: 41,532, Visits: 34,450
Backups are pretty much an IO bound operation. Check the latency and throughput on the drives.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1426761
Posted Tuesday, March 05, 2013 5:54 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 6:13 AM
Points: 925, Visits: 861
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!!!
Post #1426775
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse