We have a web application that, for government-regulated security reasons, requires each client to have their own database. As a result, we have a few thousand small databases that all have the exact same schema (each database is between 10MB and 50MB right now, but will never be larger than ~400MB)
We have a program that automatically scans through each database and upgrades the schema as there are changes to our master copy, which is working great. However, we do not have any scripted maintenance being run other than nightly backups.
Any suggestions on what else we should be running? Integrity checking, updating statistics, rebuilding indexes? No matter what we run, we'd have to make sure we can easily get a pass/fail from the script so that we can easily report the failures to investigate later the next morning (since we're not going to watch a script that is repeated thousands of times).