I have 2 lab environments, each running their own vCenter server with a local SQL Express DB. Although the environments are not very active, and don't need full SQL server, the DB eventually fills up and stops working. I guess it's probably filling with something like ESX performance data.
While making some other changes, I am wanting to get ahead of the game and 1) figure out how to clean the DB, and 2) to automate the cleaning, so maybe once a month it will clear unneeded data out.
Has anyone else already solved this issue? Any tips on what data can be dumped, and how to do that (are the needed tools included with SQL Express)?