Skip to content

sys-index-resumable-operations.md

Latest commit

 

History

History
71 lines (61 loc) · 3.49 KB

sys-index-resumable-operations.md

File metadata and controls

71 lines (61 loc) · 3.49 KB
title sys.index_resumable_operations (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 11/12/2019
ms.prod sql
ms.prod_service database-engine, sql-database
ms.reviewer
ms.technology system-objects
ms.topic language-reference
f1_keywords
sys.index_resumable_operations_TSQL
sys.indexes_TSQL
dev_langs
TSQL
helpviewer_keywords
sys.indexes
sys.index_resumable_operations
ms.assetid
author CarlRabeler
ms.author carlrab
monikerRange =azuresqldb-current||>=sql-server-2017||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.index_resumable_operations (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2017-asdb-xxxx-xxx-md] sys.index_resumable_operations is a system view that monitors and checks the current execution status for resumable Index rebuild or creation.
Applies to: SQL Server (2017 and newer), and Azure SQL Database

Column name Data type Description
object_id int ID of the object to which this index belongs (not nullable).
index_id int ID of the index (not nullable). index_id is unique only within the object.
name sysname Name of the index. name is unique only within the object.
sql_text nvarchar(max) DDL T-SQL statement text
last_max_dop smallint Last MAX_DOP used (default = 0)
partition_number int Partition number within the owning index or heap. For non-partitioned tables and indexes or in case all partitions are being rebuild the value of this column is NULL.
state tinyint Operational state for resumable index:

0=Running

1=Pause
state_desc nvarchar(60) Description of the operational state for resumable index (running or Paused)
start_time datetime Index operation start time (not nullable)
last_pause_time datatime Index operation last pause time (nullable). NULL if operation is running and never paused.
total_execution_time int Total execution time from start time in minutes (not nullable)
percent_complete real Index operation progress completion in % ( not nullable).
page_count bigint Total number of index pages allocated by the index build operation for the new and mapping indexes ( not nullable ).

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

Example

List all resumable index creation or rebuild operations that are in the PAUSE state.

SELECT * FROM  sys.index_resumable_operations WHERE STATE = 1;

See Also