sys.dm_server_suspend_status (Transact-SQL)

Applies to: SQL Server 2022 (16.x)

Returns a row for each database in a suspended state. For more information, see Create a Transact-SQL snapshot backup. Introduced in SQL Server 2022 (16.x).

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.

The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.

See Also

BACKUP (Transact-SQL) DATABASEPROPERTYEX (Transact-SQL) SERVERPROPERTY (Transact-SQL)