You have chosen to sponsor your bid up to a maximum amount of .
When I start IIS 6.0 (Windows 2003), it got 100% CPU, I am running only one website, the Image Name responsible for most CPU % usage is w3wp.exe with 20%, sqlservr.exe with 75%. The rest 5% are rest.
Look like some PHP are overloading the SQL Server query, I have SQL Server 2005.
What I need is 2 tool to show all PHP usage, to found which scripts are causing this. And a tool to debug SQL Server queries to found slow queries. I know SQL Profiler can do it, but I am not familiar to configure it. And I do not know a tool for PHP debug to show which pages are loaded at real time in IIS.
I will choose the one tell me the name of tool to debug PHP first.