The root cause for today's SQL server outage turns out to be a bug in MSSQL's handling of tempdb. There's a hotfix available for it. This Sunday, we will be taking down all On Demand SQL servers to apply the hotfix. Since we'll have them offline anyway, we'll also use this opportunity to apply some overdue Windows updates.
The maintenance window is slated for Sunday, July 17th, between 04:00 and 07:00 GMT. All FogBugz and Kiln On Demand services will be unavailable during these updates. This is a long outage and we hope to have things back up in much less time than allocated, but we'd prefer to play it safe with our scheduling.