sys.index_resumable_operations

indexes

#indexes#catalog-view

Description

2017 (14.x) and later versions SQL database in Microsoft Fabric is a system view that monitors and checks the current execution status for resumable Index rebuild or creation. : SQL Server (2017 and newer), and Azure SQL Database ID of the object to which this index belongs (not nullable).

Syntax

SELECT
*
FROM sys.index_resumable_operations
WHERE
STATE = 1;

Examples

Example 1

SELECT
*
FROM sys.index_resumable_operations
WHERE
STATE = 1;