At work, we currently having problems with one of our SQL servers.
Our problem is that it can take anywhere up to 12 hours just to crunch some data overnight.
There are no other loads on the system apart from this one module of code, but for some reason it it using up most of the servers processing power to complete it, and takes several hours to do it.
Based on stats from a program we use to monitor the server, (the program we use is up.time 5)
it shows the server workload spiking well over 100%. There are times it goes up to 300%
The pagefile drops from 60% to 40%, this happens about the same time,
Processor usage spikes up to 100% very regularly
If you can help, its much appreciated :)
can post more data if you need it