sql-server - 索引创建超时到期：SQL Server：执行超时已过期

Question

我正在一个 2 亿条记录的大表中创建一个新的非聚集索引

我为此使用 SSMS

但是由于此错误，该过程失败

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Index 'NonClusteredIndex-20210524-224640'.  (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46367.54+(SMO-master-A)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Index&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated. (Microsoft SQL Server, Error: -2)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--2-database-engine-error

------------------------------

The wait operation timed out

------------------------------
BUTTONS:

OK
------------------------------

我在选项中检查了超时，它是零，这意味着无限

我该如何解决这个错误？

标签： sql-server