How to control resource usage of my website? I'm using drupal 6 website and i don't know to check which module or script uses high resource. Below is the graph for my website Resource Usage from my hosting provider. They intimate me to control the usage. Really i don't know how i am going to solve this. And i am in shared hosting.

Any idea ?
Use the Devel module It should show you a list of queries run when
the page is loaded and the time taken to run the query. From there
you can check which query is coming from which module.
You can also try a PHP profiler which gives you a lot of metrics.
Or try disabling your modules one at a time to decide when the load
time gets really high
Another option lies in smarter caching