title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

sys.dm_server_suspend_status (Transact-SQL)

Reference documentation to explain sys.dm_server_suspend_status (Transact-SQL) dynamic management view.

MikeRayMSFT

mikeray

09/29/2022

sql

system-objects

reference

dm_server_suspend_status_TSQL

sys.dm_server_suspend_status

dm_server_suspend_status

sys.dm_server_suspend_status_TSQL

sys.dm_server_suspend_status dynamic management view

TSQL

sys.dm_server_suspend_status (Transact-SQL)

Returns a row for each database in a suspended state. For more information, see Create a Transact-SQL snapshot backup. Introduced in [!INCLUDE sssql22-md].

Column name	Data type	Description
db_id	int	ID of the database that is suspended for snapshot backup.
db_name	sysname	Name of the database suspended for snapshot backup.
suspend_session_id	tinyint	Identifies the session that suspended the database for snapshot backup.
suspend_time_ms	bigint	Time elapsed (in milliseconds) since the database has been suspended for snapshot backup.
is_diff_map_cleared	bit	`false` if the database has been suspended for snapshot backup in COPY_ONLY mode, `true` otherwise.
is_write_io_frozen	bit	`true` if the write io on the database has been frozen when the database is suspended for snapshot backup, `false` otherwise.

Permissions

Principals must have the VIEW SERVER PERFORMANCE STATE permission.