SQL Server performance -Memory,CPU

• U J

  SSCrazy

  Points: 2423

  More actions

  August 6, 2007 at 1:28 am

  #118042

  I usually faces the problems like sql server is taking more memory or CPU usage is high due to sql server , and i checks the parameters like

  1)whether AWE is enabled ?

  2)whether parallelism is enabled ?

  3)Is ther any blocking processses ?

  but apart from this can any one tell me wht needs to monitor or how to find

  *** what exactly can cause a high memusage or CPU utilization? ***

  Thnks a Ton for any  docs,links or Help !

  I am confused !

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  August 7, 2007 at 12:43 am

  #725024

  Please find the following links for more info:

  http://support.microsoft.com/kb/298475/

   

  Minaz

  "More Green More Oxygen !! Plant a tree today"