[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Context Switching

Posted on 2007-10-01
Medium Priority
Last Modified: 2011-10-03
What is excessive context switching.  I am reporting an average of 3700.  I captured this number from a baseline trace on the actual server using perfmon.  How do I rate this as really high, really low, or normal.  Comparibly it has not changed over the course of a few weeks.
Question by:rdray
  • 2
LVL 16

Expert Comment

ID: 19992768
LVL 16

Accepted Solution

SQL_SERVER_DBA earned 1000 total points
ID: 19992779

A context switching rate of 300 per second per processor is a moderate amount; a rate of 1000 per second or more is high. Values at this high level may be a problem.

You can determine whether context switching is excessive by comparing it with the value of Processor\% Privileged Time. If this counter is at 40 percent or more and the context-switching rate is high, then you can investigate the cause for high rates of context switches.

Author Comment

ID: 19992948
Thank you SQL Server DBA.  Very helpfull information.  Exactly what I needed.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question