Skip to content

Latest commit

 

History

History
33 lines (27 loc) · 2.08 KB

File metadata and controls

33 lines (27 loc) · 2.08 KB
title SQL Server, Backup Device Object | Microsoft Docs
description Learn about the Backup Device object, which provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations.
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
SQLServer:Backup Device
Backup Device object
ms.assetid 52e7febf-d5e0-4674-945b-aacc40a9ad6e
author julieMSFT
ms.author jrasnick

SQL Server, Backup Device Object

[!INCLUDE SQL Server]

The Backup Device object provides counters to monitor Microsoft [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Databases object. For more information, see SQL Server, Databases Object.

This table describes the [!INCLUDEssNoVersion] 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.

See Also

Backup Devices (SQL Server)
Monitor Resource Usage (System Monitor)