HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Pobierz pdf (Strona 8)

Backup considerations 8

Backup considerations

General recommendations

Backing up large SQL Server databases often takes a long time and ends up affecting the performance of

the primary systems. HP recommends the following for performance improvement:

• If you are using SQL Server 2008, use the built-in feature to compress backups.

• If you are using SQL Server 2005, various third-party tools are available to compress backups:

o LiteSpeed (http://www.quest.com/litespeed-for-sql-server/)

o SQL Backup (http://www.red-gate.com/products/SQL_Backup/index.htm)

o SQL Safe Backup (http://www.idera.com/Products/SQL-Server/SQL-safe-backup/)

• Using compression for backups has the following advantages, especially when using IO

Accelerators:

o Significantly reduces completion time

o Significantly reduces drive capacity needs

o Blocks databases for much smaller periods of time

• To realize the full performance benefit of the IO Accelerators for backup operations, load the

databases on IO Accelerators and, at the same time, create the backup file on the IO Accelerators.

This feature accelerates both read and write operations.

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Brak uwag

HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Strona 8