Cancelled

Slow Server

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.

Skills: PHP, SQL

See more: sql server scripts, php cpu 100, rest sql server, found server, debug queries, cpu 100, configure iis, sqlservr, slow queries, php windows 2003 server, windows server 2013, sql running 100 time, server found, slow server, windows server 2003 iis, query sql windows, debug cpu, debug cpu usage, windows sql query, exe debug, sql server query, overloading website, sql query windows, rest server php, php rest server

About the Employer:
( 5 reviews ) Sao Paulo, Brazil

Project ID: #4378726

3 freelancers are bidding on average $82 for this job

feninsoftech

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.

$55 USD in 3 days
(3 Reviews)
3.5
tarrc

If the SQL process is taking up most of the processor then it's most likely not a code issue. There's easy ways to look at the execution plans and data without needing to know a lot of Profiler. It could also be due to More

$55 USD in 3 days
(0 Reviews)
0.0
slowder

What you need to do is take a look at the DMVs for query execution stats, you're looking for the queries with the longest process time. Those will be the queries eating up 75% of your CPU. My bid is for an hour to fi More

$137 USD in 3 days
(0 Reviews)
0.0