I have a genuinely bizarre problem that I'm hoping for some insight on.
I have a report that takes a single integer parameter (WebTableID). Based on WebTableID, it runs a query gathering some information and producing a table report with some descriptions down the left, dates across the top and data in the middle.
When someone runs the report, it returns in 2-4 seconds and one of the date columns is out of order and pushed to the end. Looking at the server, there is a short 100% CPU spike.
When I run the report from my machine using the same parameter value against the same server my request takes 4 minutes to return and the dates are all in the correct order. Looking at the server, there is a 4 minute long 100% CPU spike.
There is nothing else running against that server while I am running my report and another user is running theirs (or at least nothing different). We tried running from my machine and another's, and got the same result.
While I love answering "It works fine on my machine", I'm not sure that will fly. 🙂 Plus fine doesn't account for the 4 minutes to run.
Thoughts would be appreciated, even if they are random ramblings of things you might check if this bit of randomness was happening to you.