This SQL Server has been optimized for %d concurrent queries. This limit has been exceeded by %d queries and performance may be adversely affected.

Details
Product: SQL Server
Event ID: 3629
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: This SQL Server has been optimized for %d concurrent queries. This limit has been exceeded by %d queries and performance may be adversely affected.
   
Explanation
You are using an edition of SQL Server that is licensed for a limited number of concurrent queries. This includes the Personal and Desktop editions. Those editions have a concurrent workload governor that limits them to a specific number of concurrent user queries plus a smaller number of concurrent system tasks.
   
User Action
Reduce the number of queries that execute concurrently or upgrade to another edition of SQL Server.

Additional information can be found in the Books Online topics “DBCC CONCURRENCYVIOLATION” and “SQL Server 2000 Databases on the Desktop.”

Related:

Leave a Reply