|
SQL Server Administration: Available in SQL Server 2014 Enterprise Edition since can only be done using ONLINE rebuilds.
Index rebuilds have been enhanced with the WAIT_AT_LOW_PRIORITY option. It is used to set the duration in minutes to wait, as well as behavior when blocking happens. When setting WAIT_AT_LOW_PRIORITY you also must set MAX_DURATION and ABORT_AFTER_WAIT to tell SQL how long to wait for blocking and then what to do after that amount of time has expired if blocking is still happening.
ALTERINDEX ix_RoadRaces_State
on dbo.RoadRaces
REBUILDWITH (ONLINE=ON (WAIT_AT_LOW_PRIORITY(MAX_DURATION= 10,ABORT_AFTER_WAIT=SELF))
- MAX_DURATION = time [MINUTES ]
- ABORT_AFTER_WAIT = [NONE | SELF | BLOCKERS } ]
SQLRx has worked hard to minimize the impact of monitoring SQL Servers to the point that we are able to monitor high transaction systems with little impact (1% load) on the target system. Contact us today to help you monitor your SQL servers!
| 
