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.
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. |
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 |