SQL Backup Test

This test reports statistics pertaining to the SQL server database backups.

Target of the test : A Symantec Backup server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port number at which the Symantec Backup server listens to. By default, this is NULL.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

SQL server databases count

Indicates the total number of SQL Server databases that have been backed up.

Number

 

SQL server database size

Indicates the total number of megabytes from SQL Server databases that have been backed up.

MB

 

SQL server file groups count

Indicates the total number of SQL Server file groups that have been backed up.

Number

 

SQL server filegroup size

Indicates the total number of megabytes from SQL Server file groups that have been backed up.

MB

 

SQL server tables count

Indicates the total number of SQL Server tables that have been backed up.

Number

 

SQL server table size

Indicates the total number of megabytes from SQL Server tables that have been backed up.

MB

 

SQL server file group containers count

Indicates the total number of file group containers of the SQL server that have been backed up since the Backup Exec Engine service was last restarted.

Number

 

SQL server file group container size

Indicates the amount of data of the file group containers that have been backed up since the Backup Exec Engince service was last restarted.

MB

 

Data backed up per sql server filegroup container

Indicates the average data that is backed up per SQL server file group container.

MB

The value of this measure is calculated using the formulae: SQL server file group container size / SQL server file group containers count

SQL server table containers count

Indicates the total number of SQL server table containers that have been backed up since the Backup Exec Engince service was last restarted.

Number

 

SQL server table container size

Indicates the amount of data of the table containers that have been backed up since the Backup Exec Engine service was last restarted.

MB

 

Data backed up per sql server table container

Indicates the average of data that is backed up per SQL server table container.

MB

The value of this measure is calculated using the formulae: SQL server table container size/ SQL server table containers count

Total utility partitions count

Indicates the total number of utility partitions of the SQL server that have been backed up since the Backup Exec Engine service was last restarted.

Number

 

Total utility partition size

Indicates the amount of data of the utility partitions that have been backed up since the Backup Exec Engine service was last restarted.

MB

 

Data backed up per utility partition

Indicates the average data that is backed up per utility partition.

Percent

The value of this measure is calculated using the formulae: Total utility partition size/ Total utility partitions count