Limited number of concurrent queries

Hi, I have this message in the event viewer:

Event Type: Information
Event Category: (2)
Event ID: 17055
Date: 9/25/2009
Time: 8:43:24 AM
User: N/A
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, 2009 at 08:10 PM in Default

avatar image

Alberto De Rossi
148 7 9 12

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

2 answers: sort voted first

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, 2009 at 08:18 PM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(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, 2009 at 12:33 AM

avatar image

Robert L Davis
172 1 2 4

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Oct 20, 2009 at 08:10 PM

Seen: 3524 times

Last Updated: Oct 21, 2009 at 10:35 AM

Copyright 2018 Redgate Software. Privacy Policy