• 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. Consult your SA