Description of online property updating
Generally, the session will wait for another session that is using the transaction.
One of the most prestigious and successful strands of Oxford’s scholarly publishing, the Handbook series contains in-depth, high-level articles by scholars at the top of their field.Handbook articles review the key issues and cutting-edge debates, as well as providing arguments for how those debates might evolve.Revolutionary changes to the publishing program ensure that all Handbooks are available online as well as in print, and monthly updates introduce articles in advance of print publication ensuring the most current, authoritative coverage.Occurs when SQL Server polls the version transaction manager to see whether the timestamp of the earliest active transaction is later than the timestamp of when the state started changing.If this is this case, all the snapshot transactions that were started before the ALTER DATABASE statement was run have finished.
Search for description of online property updating:
If the task that is being waited on is in an I/O process, this type does not indicate a problem.