I have a SharePoint 2013 server whose SP_UsageAndHealth database started growing out of control this morning. It's grown from about 50GB to a terrabyte and a half in the space of a couple of hours. My research indicates this DB is a temporary repository for - as the name suggests - usage and health data, but how temporary? Can I shrink it? Can it be dropped or deleted or something and start from scratch? The TRANSACT SQL query that was obviously filling it was killed with no obvious ill effects but I need that space back.
Ah got it. In SharePoint's central administration web app there's settings for how this gets populated in monitoring, as well as two jobs which tidy it on a schedule. They can be run now with a button, and then dbcc shrinkdatabase tidies it up.