our asp site is taking very high cpu usage
what are the reasons for such high usage.
we have used stored procedures n also indexed the tables


is it possible to detect cpu usage and display a custom message to users to hold for some time if usage is very high

You can look for an ASP profiler and examine your code with that. My guess is there could be a bug causing a loop to run longer than necessary, but that's just a wild random guess.

What version of IIS are you using?

What version of IIS are you using?

Its IIS 6

I dont have any problem on IIS7 i will try my site on iis6 in a few days.