Diagnoses of SQL server eaten CPU and Memory

• Paresh Prajapati

  SSCertifiable

  Points: 7567

  More actions

  December 23, 2008 at 10:56 pm

  #155051

  SQL server has around 50 databases .

  SQL server eat 70 to 80 percent CPU ans 1.6 GB Memory.

  How can i Diagnoses them?

  Is there any way?

  I want to know that which it is eatn to much..? and want o clerift that due to this it is eat more CPT and Memory.

  Can u give me ur sugession/idea to improve performenence,and how can we solve therm.

  Please help me to Diagnoses Utilization of SQL server 2005.

  _____________________________________________________________________________________________________________
  Paresh Prajapati
  ➡ +919924626601
  http://paresh-sqldba.blogspot.com/[/url]
  LinkedIn | Tweet Me | FaceBook | Brijj

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  December 23, 2008 at 11:24 pm

  #917233

  The white paper at this link is where you want to start your research - http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

  Please post with any specific questions that come from your reading and investigation.

  Hope this helps!

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot