January 21, 2010 at 3:51 pm
Forgive me if I sound like a complete fool, but does SQL Server run Index Rebuild Maintenance plans in the background? Reason I ask is, I created a maintenance plan to rebuild all indexes and executed the plan. But the plan completed (successfully) way too quickly for it to actually have done anything. I ran a script to show % of fragmentation, and as I suspected, nothing had changed.
I took the generated script from the plan, and ran it as a query...the script took longer to complete, but running the script to show % of fragmentation showed it had actually performed the reindex.
by the way, I was testing my maintenance plan scripts on a dev database....:-)
January 23, 2010 at 4:09 pm
It does not run in the background per se. The maint plan should be executing the same script and taxing your server just the same as if you ran the script it generated manually.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 23, 2010 at 7:43 pm
Perhaps the tables are small, so although they are fragmented, they are too small to defragment.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply