| title | SQL Server, Backup Device object | ||
|---|---|---|---|
| description | Learn about the Backup Device object, which provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| ms.date | 12/04/2023 | ||
| ms.service | sql | ||
| ms.subservice | performance | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
The Backup Device object provides counters to monitor Microsoft [!INCLUDE ssNoVersion] backup devices used for backup and restore operations. Monitor backup devices when you want to determine the throughput or the progress and performance of your backup and restore operations on a per device basis. To monitor the throughput of the entire database backup or restore operation, use the Backup/Restore Throughput/sec counter of the [!INCLUDE ssNoVersion] Databases object. For more information, see SQL Server, Databases Object.
Note
The SQL Server Backup Device counter are not currently visible from sys.dm_os_performance_counters. On Windows, the counters can be viewed from System Monitor.
This table describes the [!INCLUDE ssNoVersion] Backup Device counter.
| SQL Server Backup Device counters | Description |
|---|---|
| Device Throughput Bytes/sec | Throughput of read and write operations (in bytes per second) for a backup device used when backing up or restoring databases. This counter exists only while the backup or restore operation is executing. |