x

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?

more ▼

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

Alberto De Rossi gravatar image

Alberto De Rossi
148 7 7 9

(comments are locked)
10|1200 characters needed characters left

2 answers: sort oldest

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.

more ▼

answered Oct 20 '09 at 08:18 PM

Kev Riley gravatar image

Kev Riley ♦♦
50.8k 43 49 76

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)
10|1200 characters needed characters left

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.

more ▼

answered Oct 21 '09 at 12:33 AM

Robert L Davis gravatar image

Robert L Davis
172 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x341
x7

asked: Oct 20 '09 at 08:10 PM

Seen: 2806 times

Last Updated: Oct 21 '09 at 10:35 AM