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 [url removed, login to view] with 20%, [url removed, login to view] 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.
3 freelancers are bidding on average $82 for this job
Hi, I think this problem is not related to PHP. There is some join issues in SQL queries that is taking much time to complete. I have 8 years experience in SQL Server and can resolve this problem.