My hosting company announced me that my sites consume to much resources but hey could not tell me which script. Where should I start in checking and fixing the issue?
You are going to need some logs in order to find out what is causing the issue. If you can SSH in. Run the below. ps aux mysqladmin processlist ; top Those should tell you what script is causing the issue. If you cant SSH in, you will need to contact your host to provide you this information, otherwise there is no way to know which of your scripts are causing the issue.
exactly like @samirj09 said. if you have ssh access you need to harvest some information in order to determine where exactly the issue is coming from. you can use 'ps auwxf' to list all running processes on your server. you can also take a snapshot using 'top -n1 -b' and post it here as it will show a nice picture of what's going on. use 'mysqladmin processlist ;' to see what mysql is doing and/or use 'mytop' to see the slow queries (if any) in real time. also when you say 'my site is consuming too much resources' can you provide some numbers so we can know 'how much' is this? also, what operating system you're on, what applications you're running, are they based on wordpress, joomla etc.... how much resources you have? if you want to get the best answers and help from the awesome community in here, make sure you provide us with as much information as possible . HTH
Do you still require help with this? Chat me on skype - cesurasean , and we can discuss the project more. Thank you.