It does work for auto grow and shrink, also cleans up dropped objects or indexes.
Done anything like that recently?
Per MSDN, it does all that, but when it's just cleaning stuff up, it only runs for a very short time and is very light on locks. But when it's involved in auto-shrink? Well, we already know that's a huge performance killer.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon