Viewing 2 posts - 16 through 17 (of 17 total)
How large are the databases on which maintenance is being performed? Terabytes??
Are you using Maintenance Plans or custom scripts? In my experience, custom scripts (especially Ola's) are more...
January 31, 2014 at 12:56 pm
#1685182
For the tables being queried, when was the last index maintenance performed?
Run a DBCC Showcontig on the tables in question.
January 31, 2014 at 12:45 pm
#1685181