Posted - 12/12/2013 : 00:26:14
| I work with a 260GB vendor supplied database with all of the indexes created.
A couple of weeks ago a particular process started taking 5-7 minutes to run that used to run in seconds. It did this for a couple of days and then went back to normal. It's happened a few times since.
The stored procedure is 500+ lines and accesses over 25 tables with probably 100-200 indexes.
The problem occurred yesterday and I ran a trace on it while it was misbehaving. Things were ok today and I ran another trace.
What would cause the same process to act so differently?