SQL Server performance -Memory,CPU

  • U J

    SSCrazy

    Points: 2420

    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

    Please find the following links for more info:

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

     

    Minaz

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply