Web Services bog down during busy times, looking for ways to id the probelm
We run, servier 2003 sp2
Xeon 2ghz with 6 gb ram
runs IIS, Coldfusion 8 and ms Sql 2005
During month end we the server frequently slows down or stops serving up web pages. Sometimes i see SQL taking 80% of the processer and Jrun at 20%
what would you do first to track down the problem or what would u recommend doing to prevent the slowdown?