SQL Server: Backup Device Object

The Backup Device object provides counters to monitor Microsoft® SQL Server™ backup devices used for backup and restore operations. Monitoring backup devices is useful when you want to determine the throughput of specific backup devices, rather than the entire database backup or restore operation, which may be using several backup devices in parallel. By monitoring the throughput of a backup device, you can determine 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 SQL Server Databases object. For more information, see SQL Server: Databases Object.

These are the SQL Server Backup Device counters.

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.

See Also

Disk, Tape, and Named Pipe Devices

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.