100% CPU Usage
I am having aproblem. I have ASP.Net application installed on a web server. As the number concurrent users increase, CPU usage goes to 100% . I tested with ACT and with 100 simulteneous users and immediately CPU usage went to 100%. Even with 50 users the result was the same only a few times it came down. With 10 users it worked perfectly.
Its a simple page, yes i am populating combo boxes from database and also one combo dependent on other but still i dont find any optimization in the code.
Are there any settings to be done on IIS or in machine.config to support more users?
I am connecting to SQL server which is on some other machine than the web server. Can that SQL server coz any problems which can shoot 100% CPU usage on web server?
please reply asap