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 !