Follow


InfiniGuard Configuration and Testing Results

In the example backup / restore sequence outlined below, the Windows Server was a bare-metal server with a single fibre channel volume supporting the 50GB database, data and transaction log coming from Infinibox storage. The server has 2 x 8GB FC HBA's and 1 x 10GB ethernet device. Backups are performed and sent to InfiniGuard through the default route. The following steps are required to insure the Windows Server can access the share created on InfiniGuard.

Add InfiniGuard to AD or Windows Domain

Add Windows user performing the backup to InfiniGuard. This example uses the Administrator account. Use what ever user that is authorized to perform backups for SQL Server.

Create a CIFS share. Specify which users have access to the share.

In Share Access tab, add Windows User.

 
At this point, you can use either the SQL Management Studio backup panel or use the command line to drive the backup.
Here is the backup screen showing the added network pointer to the CIFS share created above. Use the standard Windows network connection string as a "disk" device to backup to.

 
Or you can use the Powershell command line.

SQL Backup: Single channel
SqlCmd -E -Q "Backup Database AdventureWorks2008R2 to
DISK='\\172.31.32.103\glennfcifs\Backup\AdventureR2.bak' with format"


Multi-channel backup
SqlCmd -E -Q "Backup Database AdventureWorks2008R2 to
DISK='\\172.31.32.103\glennfcifs\Backup\Adventure1c.bak',
DISK='\\172.31.32.103\glennfcifs\Backup\Adventure2c.bak',
DISK='\\172.31.32.103\glennfcifs\Backup\Adventure3c.bak' with format

You do need to specify multiple file names within the command sequence to insure that the backup launches multiple processes and creates multiple backup files.


SQl Restore: Single channel
SqlCmd -E -Q "Restore Database AdventureWorks2008R2 from
DISK='\\172.31.32.103\glennfcifs\Backup\AdventureR2.bak' with replace"


SQL Restore Multi-channel
SqlCmd -E -Q "Restore Database AdventureWorks2008R2 from
DISK='\\172.31.32.103\glennfcifs\Backup\Adventure1c.bak',
DISK='\\172.31.32.103\glennfcifs\Backup\Adventure2c.bak',
DISK='\\172.31.32.103\glennfcifs\Backup\Adventure3c.bak' with replace"


The following is an example test performed in the Infinidat Waltham lab.

Single channel backup
Z:\> ./backup-1.ps1
Processed 3171048 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Data' on file 1.
Processed 2 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Log' on file 1.
BACKUP DATABASE successfully processed 3171050 pages in 55.215 seconds (448.679 MB/sec).
Multi channel backup
Z:\> ./backup-3.ps1
Processed 3171048 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Data' on file 1.
Processed 2 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Log' on file 1.
BACKUP DATABASE successfully processed 3171050 pages in 46.459 seconds (533.240 MB/sec).


Single channel restore
Z:\> ./restore-1.ps1
Processed 3171048 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Data' on file 1.
Processed 2 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Log' on file 1.
RESTORE DATABASE successfully processed 3171050 pages in 54.928 seconds (451.023 MB/sec).


Multi channel restore
Z:\> ./restore-3.ps1
Processed 3171048 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Data' on file 1.
Processed 2 pages for database 'AdventureWorks2008R2', file 'AdventureWorks2008R2_Log' on file 1.
RESTORE DATABASE successfully processed 3171050 pages in 59.483 seconds (416.485 MB/sec).

 
The first backup will be a full-data copy to InfiniGuard. Any subsequent backup will be de-duplicated. 

A slight performance improvement is noticed between single channel backup and multi channel backup.

For the restores, note that the single channel restore actually performs faster than the multi-channel restore. Some of the SQL documents refer to the fact that restores are performed sequentially through each of the files, rather than in parallel, the way that backup is performed.

Was this article helpful?
0 out of 0 found this helpful

0 out of 0 found this helpful

Comments