System Context Switches/Sec

• Sandy2704

  SSCrazy

  Points: 2156

  More actions

  March 16, 2010 at 3:07 pm

  #217898

  Hello guys,

  I noticed abnormality in System Context Switches/sec counter......The average value lies between 12,000 - 13,000 /Processor....... (I guess the average value should be less than 1,000/Processor)

  How do i solve this issue? what are the factors that i need to consider.....

  Regards,

  Sandeep

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 17, 2010 at 6:47 am

  #1135173

  It depends, and it is not really something you have much control over anyway.

  The following document discusses how to measure performance, and where to focus your improvement efforts.

  Microsoft White Paper - Waits and Queues Methodology

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  March 17, 2010 at 6:51 am

  #1135178

  You need to determine which program is having the context switchs by using the process explorer utility and then post the results.

  http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

  SQL = Scarcely Qualifies as a Language

• Sandy2704

  SSCrazy

  Points: 2156

  More actions

  March 17, 2010 at 6:51 am

  #1135180

  Thanks buddy

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 17, 2010 at 6:53 am

  #1135181

  You are welcome.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi