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