The speed of your backups can be retrieved from the msdb..backupset table. The backup_start_date, backup_finish_date, and backup_size fields provide the necessary
details to calculate the backup speed. Note that the backup
size is not necessarily identical to the database size, as SQL
Server does not back up data pages that contain deleted data.
See this article for details.
Here's a script that displays the backup speed for all your
databases (at least for the backups whose details are still present
in the msdb tables):
SELECT database_name, backup_start_date,
CAST(CAST((backup_size / (DATEDIFF(ss, backup_start_date,
backup_finish_date))) / (1024 * 1024) AS NUMERIC(8, 3)) AS
VARCHAR(16)) + ' MB/sec' speed
FROM msdb..backupset
ORDER BY database_name, backup_start_date |
Document history
11/17/2008 | Initial release. |