February 25, 2009 at 6:26 am
There is a DB maintence (Optimizations) job set up (via maintenance plans) which reorganizes data and index pages and removes unused space from the database.
My boss saw that it had not run in awhile so he kicked it off. Only problem is that the Transaction log backups kicked off at the same time and now it looks like they are both running and probably locking each other out. SP_WHO and SP_WHO2 doesn't show me any locks.. How can I identify if they are inded locked and if they are.. which can I safely kill?????
February 26, 2009 at 6:53 am
If there is nothing in blcoked state then no issue to leave it as is.
MJ
February 26, 2009 at 7:32 am
I agree. You've got two resource-intensive jobs running and competing for CPU. They'll finish eventually but obviously the process will run longer. How are you removing unused space from the database? If you're shrinking the data file AFTER an index rebuild, you're basically killing the work done by the rebuild as the shrink will most certainly fragment them again.
-- You can't be late until you show up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply