We need some help to figure out what is causing SQL to cause 100% CPU use.
Either we have increased the amount of user traffic and need more CPU which is not likely the case since December is a low traffic month for us.
Or we have script(s) with poorly-optimized SQL queries that are not scaling well with user traffic.
Even after restarting the server it goes to 100% right away.
We need help to figure this out.
The Server is Windows and the website is written in classic ASP.