Skip to content

Latest commit

 

History

History
35 lines (28 loc) · 2.28 KB

File metadata and controls

35 lines (28 loc) · 2.28 KB
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.
ms.custom
ms.date 07/12/2021
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
SQLServer:Backup Device
Backup Device object
author WilliamDAssafMSFT
ms.author wiassaf

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.

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 [!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