Quote:
Originally Posted by superdudeGTGGG
No my SQL server is on the same box as the BES.
I have noticed an informational message just before the 20640 warning is logged.
Event ID: 17055
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
|
You are using MSDE or Personal Edition of SQL Server. These have a workload governor that limits the number of concurrent queries that can be executed on the server. See below topic for more details:
http://msdn.microsoft.com/en-us/libr...sql.80%29.aspx
So if you need to run more queries concurrently then you need to upgrade to standard or workgroup or enterprise edition depending on your requirements.