I have this one index that's 85.71% total fragmentation and 55.35% page fullness...why not lets start with an index rebuild, but I get this error.
Can this be done without taking my instance offline?
TITLE: Microsoft SQL Server Management Studio
------------------------------
Rebuild failed for Index 'idx_last_success_download'. (Microsoft.SqlServer.Smo)
For help, click: http://ift.tt/1ALkNN3
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
For help, click: http://ift.tt/1ALkO3i
------------------------------
BUTTONS:
OK
------------------------------
Aucun commentaire:
Enregistrer un commentaire