SQL Server performance -Memory,CPU

  • 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 !

  • Please find the following links for more info:




    "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