SQL Server 2008 R2 Express - 实例不断启动数据库
我有 3 个实例运行 SQL Server 2008 R2 Express，以尝试规避 Express 版本的 1GB 限制。实例 1 (SQLExpress) 连接到我最繁忙的网站，为大约 3000 个并发在线用户提供服务。该数据库运行正常。
我还运行另外两个实例（SQLExpress1 和 SQLExpress2），它们都连接到更安静的站点。在这两个实例上，我都看到数据库不断启动：
11/02/2010 20:18:24，spid53，未知，正在启动数据库“historiaslush_forums”。 11/02/2010 19:34:43，spid52，未知，启动数据库“historiaslush_forums”。 11/02/2010 19:17:17，spid54，未知，启动数据库“historiaslush_forums”。 11/02/2010 19:02:37，spid51，未知，启动数据库“historiaslush_forums”。 11/02/2010 18:54:27，spid51，未知，启动数据库“historiaslush_forums”。 11/02/2010 18:41:27，spid51，未知，启动数据库“historiaslush_forums”。 11/02/2010 17:56:28，spid51，未知，启动数据库“historiaslush_forums”。 11/02/2010 17:44:13，spid52，未知，启动数据库“historiaslush_forums”。 11/02/2010 17:33:25，spid53，未知，启动数据库“historiaslush_forums”。 11/02/2010 17:33:21，spid53，未知，启动数据库“historiaslush_forums”。 11/02/2010 17:19:04，spid51，未知，启动数据库“historiaslush_forums”。 11/02/2010 17:18:55，spid53，未知，启动数据库“historiaslush_forums”。
以前有人见过这种行为吗？它仍然与表情版的残缺功能集相关吗？
谢谢
I have 3 instances running of SQL Server 2008 R2 Express, to try and circumvent the 1gb limit for express editions. Instance 1 (SQLExpress) is attached to my busiest web site, servicing around 3000 concurrent online users. This database functions normally.
I am also running two other instances (SQLExpress1 and SQLExpress2) both attached to much quieter sites. On both instances I am seeing the databases constantly starting:
11/02/2010 20:18:24,spid53,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 19:34:43,spid52,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 19:17:17,spid54,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 19:02:37,spid51,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 18:54:27,spid51,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 18:41:27,spid51,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 17:56:28,spid51,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 17:44:13,spid52,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 17:33:25,spid53,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 17:33:21,spid53,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 17:19:04,spid51,Unknown,Starting up database 'historiaslush_forums'.
11/02/2010 17:18:55,spid53,Unknown,Starting up database 'historiaslush_forums'.
Has anyone seen this behaviour before? Is it still linked to the crippled feature set with the expression edition?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
默认情况下，SQL Express 数据库创建为
AUTO_CLOSE ON。因此，一旦最后一个会话释放对其的访问权限，它们就会关闭。它们将在下次访问时自动打开。 AUTO_CLOSE 数据库在打开时运行优化的恢复，因此它们的打开不像完全成熟的数据库打开那么糟糕。但尽管如此，如果您愿意，您可以关闭 AUTO_CLOSE：请注意，AUTO_CLOSE ON 数据库在企业版上的行为相同，因此这与 Express 限制无关。
By default SQL Express databases are created as
AUTO_CLOSE ON. As such, they are closed as soon as the last session releases access to it. They will auto-open on next access. AUTO_CLOSE databases run an optimized recovery when opened so their openning is not as bad as a fully fledged database open. But none-the-less, you can turn AUTO_CLOSE OFF if you wish:As a note, an AUTO_CLOSE ON database would behave the same on Enterprise Edition, so this is not related to Express restrictions.
您拥有的数据库可能设置了 AutoClose 属性
The database you have might have the AutoClose property set on