Thanks for the article Ross, there are definitely some things there I didn't know.
You've prompted me to check the maintenance on my own servers. Unfortunately, I've come across a potential issue. Two active database one one of my servers (15 active / 15 passive total) don't look like they're performing maintenance properly. The "Database Maintenance Duration" counter for these DBs is climbing in front of my eyes. One of them is over 1,000, the other over 20,000. How is the counter climbing when it's supposed to be measured in hours, not seconds?! Is my perfmon wrong? For all other databases the counter stays resolutely at 0.
There are no 733 or 735 alerts in the application log.
Any pointers appreciated!
Richard