Number of times Adaptive Server switched context for a number of common reasons. “% of total” reports the percentage of times the context switch occured because of specific reason as a percentage of the total number of task context switches for all Adaptive Server engines combined.
“Task Context Switches Due To” provides an overview of the reasons that tasks were switched off engines. You can investigate he possible performance problems shown in this section by checking other sp_sysmon output, as indicated in the sections that describe the causes.
For example, if most of the task switches are caused by physical I/O, try minimizing physical I/O by adding more memory or reconfiguring caches. However, if lock contention causes most of the task switches, check the locking section of your report.
See “Lock Management” for more information.
