SQL Server takes 95% of my processor

• vishnu.mediinfotec

  Newbie

  Points: 1

  More actions

  October 24, 2013 at 10:26 pm

  #299651

  Hi,

  We have a database server where SQL Server 2008 Enterprise edition is installed.

  Our processor is always running above 90%. Since its a virtual machine, we doubled the processor for the first day SQL Server was occupying 60% of the processor but later on it is again occupying above 90%?

  Any suggestion on what is the actual reason for my processor to go beyond 90% and on how it can be controlled.

  Is it that my database activity is too high and I am using lesser processor. How can one find what kind of processor capacity is required for their database usage?

  Thanks in advance. Please let me know if any additional information is required to suggest a solution for the same.

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  October 25, 2013 at 3:31 am

  #1661558

  Tune the queries, optimise the indexes or add more hardware.

  https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass