Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a shared webhosting server based on Windows 2008/IIS 7/Plesk 11.0 .Most of the time Server's CPU usage is over 80% and MS SQL Server process uses most of the CPU/RAM resources. I want to know how I could figure out which website is using more resources and then limit it or terminate it completely.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Is everyone sharing the same application pool? Or do you have it setup to be separate for each site?

Regardless open IIS Manger and click on Worker Processes enter image description here

If the site are using different pools you will easily be able to see which one is using the most resources. You can also click on the pool from the list and see incoming requests (Pools can also be found in task manger since each individual pool gets corresponding process.)

It would help to know how many websites your hosting and is it shared pool vs dedicated. I usually setup dedicated pools for each site so they can be managed more easily. It can also prevent problems like your having.

You can change a sites app pool by clicking on the site in IIS, and going to basic settings. Click select to pick a new pool. Make sure to add a new pool under Application Pools in IIS beforehand. It will be a v2.0 framework and integrated pool.

Edit:

For MsSQL you can use the Performance Monitor under the Admin tools to add the counters for each db. To see which one is eating the most cycles.

Go to Add Counters, go to SQLServer:Datbases, you can add each sql database instance individually

share|improve this answer
    
He is asking about MSSQL not mySQL –  Zypher Dec 19 '12 at 21:24
    
whops didnt pay attention to that. will edit in a sec –  Sarge Dec 19 '12 at 21:25
    
Thanks but The problem is MSSQL (I just wrote SQL Server) –  ImanGh Dec 19 '12 at 21:26
    
there is also a good answer over at stackoverflow, if you dont want to use solution above. stackoverflow.com/questions/28952/cpu-utilization-by-database –  Sarge Dec 19 '12 at 21:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.