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)