SP takes long time but reboot fixes it
I have a stored procedure that normally takes 1-2 seconds to run. It is just a Select, no action.
However, after a couple of days, it then takes 7-8 minutes to run.
The tables are not being heavily modified.
If I stop the SQL server and its service then start it again and run the same stored procedure, it runs again in under 2 seconds.
I am doing a nightly "Reorginize data and index pages" with the option checked for "Change free space per page percentage to" set to 10%.