I am currently having the problem of w3wp.exe process running at high CPU utilization. This is on a machine that has Windows Server 2003, IIS 6.0, Sharepoint 2007 Standard Edition and Microsoft SQL Server. The interesting pattern is that it occurs everyday at around 2pm, on checking the event logs, nothing was logged around that time. Using the IISapp.vbs, I was able to pinpoint to the Sharepoint Application Pool as the culprit.
But now I am stumped, how do I find out which process specifically within Sharepoint that is causing it, e.g. is it a timer job, if so, which one? Or is it some other Sharepoint process? How do I go about finding out?