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|
ORDER BY database_name, backup_start_date
Discuss or comment on this article on our Facebook group.