For SQL server 2014 additional parameters like WAITATLOWPRIORITY, MAXDURATION, and ABORTAFTERWAIT can also be used. Below is an example of ALTER INDEX REBUILD with MAXDOP =1:USE AdventureWorks2014GOALTER INDEX PKEmployeeBusinessEntityIDON HumanResources.EmployeeREBUILD WITH (MAXDOP=1, ONLINE= ON) GO. Lower MADOP setting can also with online Index rebuild operation. When this problem occurs, you can by limiting the number of processors to use for the index operation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |