Performance Issues when backing up BI db's

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Performance Issues when backing up BI db's

Performance Issues when backing up BI db's

Rate Topic

Display Mode

Topic Options

Author

Message

smthembu

Posted Tuesday, March 05, 2013 4:46 AM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 1:30 AM
Points: 772, Visits: 726

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

GilaMonster

Posted Tuesday, March 05, 2013 5:19 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 37,635, Visits: 29,886

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

smthembu

Posted Tuesday, March 05, 2013 5:54 AM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 1:30 AM
Points: 772, Visits: 726

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 »

Permissions