our server is running win2003 with mssql 2005 on the same box with 2GB ram. the website itself is based on dnn 4. We are seeing these high cpu usage spikes (mssql) of 95-99% even with no traffic.sometimes they appear with regular intervals with no traffic.
What can possible cause this? how do find the root cause?