We have a web site which has over the past 12 months become very busy and is now handling about 50,000 transactions each day.
I have been watching the server performance and the CPU spikes a lot so I need to find any inefficiencies in the code which could affect performance. Are there any tools out there to help me with this ? I need to see where in the code the spikes are happening, how many conncurrent db connections are happening etc ... This will allow me to root out any areas of the application which are inefficient and will cause increasing rpoblems as we scale our business ...
Thanks so much,