dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Measure-DbaBackupThroughput

Determines how quickly SQL Server is backing up databases to media.

Returns backup history details for some or all databases on a SQL Server.
Output looks like this

SqlInstance: sql2016
Database : SharePoint_Config
AvgThroughputMB : 1.07
AvgSizeMB : 24.17
AvgDuration : 00:00:01.1000000
MinThroughputMB : 0.02
MaxThroughputMB : 2.26
MinBackupDate : 8/6/2015 10:22:01 PM
MaxBackupDate : 6/19/2016 12:57:45 PM
BackupCount : 10

Screenshots

Examples

To parse every backup in msdb’s backuphistory for stats on all databases

Measure-DbaBackupThroughput -SqlInstance sql2016

To parse every backup in msdb’s backuphistory for stats on AdventureWorks2014

Measure-DbaBackupThroughput -SqlInstance sql2016 -Databases AdventureWorks2014

To process the last full, diff and log backups every backup for all databases on sql2005

Measure-DbaBackupThroughput -SqlInstance sql2005 -Last

To process the last log backups every backup for all databases on sql2005

Measure-DbaBackupThroughput -SqlInstance sql2005 -Last -Type Log

To process backup calculations for the last week

Measure-DbaBackupThroughput -SqlInstance sql2016 -Since (Get-Date).AddDays(-7)

To process backup calculations, limited to the last year and only the bigoldb database

Measure-DbaBackupThroughput -SqlInstance sql2016 -Since (Get-Date).AddDays(-365) -Databases bigoldb

Get-Help

From PowerShell, execute Get-Help Measure-DbaBackupThroughput -Detailed for more information on this function.

Source Code

Want to see the source code? View Measure-DbaBackupThroughput.ps1 on GitHub
 

Related commands