| http://www.w3.org/ns/prov#value | - Preemptive is a non-cooperative, which generally happens with processes that are running outside SQL. This is not good for SQL Server as it is a particular external process which makes SQL Server to yield.Sometimes it can be fixed by re-indexing/de-frag but most of the times it happens if there are a lot of Context Switches on your server.
|
