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

Please note that documentation and command names may be out of date while we work furiously towards 1.0


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