17052:
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 25 queries and performance may be adversely affected.
日志频繁出现类似以上日志,是什么问题?
最近数据库经常假死(正常只要几秒钟的操作要等上1-2分钟),重启sql sever服务后,软件可正常使用。
------解决方案--------------------
应该是你所安装的sql版本只允许8个并发数,出现这个错误应该查下为什么并发数会超过8。
http://documentation.red-gate.com/pages/viewpage.action?pageId=20743456
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/fc897b94-1a74-4fc1-a5a2-0a16d7dc45ba/this-sql-server-has-been-optimized-for-8-concurrent-queries-this-limit-has-been-exceeded-by-8?forum=transactsql