We have asp.net sites based on dotnetnuke architecture and we are having two load balancing server with 2 gigs and with 24GB Ram. and SQL Server is with 48GB Ram. But still we are having some problem with sites and its heating 100% cpu usage.
We have multiple instance of this site for each client wise one virtual directory for each client and domain. I need to find out what process is causing that problem.
Its not all time at 100% but during some time like for 2 minutes its bags to 100% cpu usage i need to find out that why its causing we have lots of pages in our site. I need to find out whats going on with application.
We have tried RedGate Profile for code issues and we have resolved that issue but still there was some part of application that is causing problem and we need to find out that.
Is there any tool of anything that is there from which we can find out webserver load and reason for cause of the going for 100%.
We have also profiled our SQL Server and its running normal there is only problem with web server only.
Any tip or help will be greatly appreciated.
Thanks in advance for any help or tip.