I have a SQL Server Express instance with 20,000 databases (twenty thousand databases).. and the service won't start.
I get error message 1053:
The service did not respond to the start or control request in a timely fashion.
I'm just doing some testing of sharding, trying out some ideas. Apparently, I shouldn't leave this many databases attached at the same time... I can work around this... I just wish I knew more how to predict / forecast regarding the real limits of SQL Server 2012 Express.
There is insufficient system memory in resource pool 'internal' to run this query.
Script level upgrade for database
masterfailed because upgrade step
msdb110_upgrade.sqlencountered error 701, state 123, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the
masterdatabase, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
I assume I should uninstall and reinstall, and then attach half as many databases and split the load between two database servers?