Limited number of concurrent queries

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?

asked Oct 20 '09 at 08:10 PM in Default

Alberto De Rossi
148 ● 5 ● 7 ● 9

(comments are locked)

2 answers:

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.

answered Oct 20 '09 at 08:18 PM

Kev Riley ♦♦
46.1k ● 39 ● 43 ● 69

Yes, your right, I forgot to tell you the edition and it is actually Personal Edition. THANKS!

Oct 21 '09 at 04:58 PM Alberto De Rossi

(comments are locked)

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.

answered Oct 21 '09 at 12:33 AM