Hi, I have this message in the event viewer:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 9/25/2009
Time: 8:43:24 AM
User: N/A
Computer: SERVER_INASSAII
Description:
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.
Can anyone tell me please how do you optimize SQL Server for a limited number of queries?
You haven't stated what version or edition of SQL you are using.
Could it be that you are using one of the entry level products, MSDE or Personal edition? These had resource governors to limit the amount concurrency.
If so, you may want to look into using the newer versions of these, namely SQL Server Express - this edition is not limited in this way.
Yes, Kev is right. This error was specific to the MSDE and Peronal editions of SQL Server 2000. You should consider upgrading to SQLExpress 2005 or 2008.
