在 MSSQL Server 中,每个星期六都会启动维护计划,重建一些索引。在上个月,它总是在几个小时后失败并显示消息:该步骤失败。
Executed as user: NT AUTHORITY\SYSTEM.
...PK_dbo.__MigrationHistory] ON [dbo].[__MigrationHistory] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, FILLFACTOR = 90)
[SQLSTATE 01000] (Message 0) ITEM 2 FROM 508 [SQLSTATE 01000] (Message 0) ALTER INDEX [PK_dbo.__MigrationHistory] ON [dbo].[__MigrationHistory] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, FILLFACTOR = 90)
[SQLSTATE 01000] (Message 0) ITEM 3 FROM 508 [SQLSTATE 01000] (Message 0) ALTER INDEX [PK_dbo.ONEINDEX] ON [dbo].[TABLE1] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, FILLFACTOR = 90)
[SQLSTATE 01000] (Message 0) ITEM 4 FROM 508 [SQLSTATE 01000] (Message 0) ALTER INDEX [PK_dbo.INDEX] ON [dbo].[TABLE2] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
... The step failed.
我怎样才能进一步调查这个问题?我想某处有超时,但需要找出答案。
您发布的那段文字究竟来自哪里?
对于维护计划,您有三四个诊断信息(错误消息等):
您发布的内容不包含错误消息,因此仅凭这一点我们无能为力。查看我上面列出的其他资源,看看它们是否有帮助。