I have a proc that runs very slowly on my prod server, it take over 3 minutes to return results. If I make a backup of the DB and move it to my stage server the same exact procs run in two seconds.
I'm assuming this must mean that the slowness is caused by something in my prod environment?
If so, what can I look for?
Is it safe to say it's nothing in the DB, since it runs fine on stage?
The prod server is not very busy btw..in fact it is barely being used..
View Complete Post