when my portal is running webserver CPU usage became 100%. then i checked by SQL server profiler. too many procedure is running. getmodule, gethtmltext, getdatabaseversion, sp_reset_connection et.c.
sometimes many searching procedures are running and CPU usage 100%. at the time if i view my portal on browser underconstruction.html returns.
webserver: pentium 3, 497Mhz 2 CPU, 1GB ram, iis 6, SQL server 2005, .net framework 2.0
how do i fix it? i haven't any idea. please give me advise.
thank you