Home > Archive > microsoft.public.sqlserver.server > November 2002 > How do I change the optimal concurrent query count





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author How do I change the optimal concurrent query count
Richard Sutterfield

2002-11-20, 3:23 pm

I have an instance where we are getting some strange errors in our
application after which no-one can print reports (using Crystal Reports).
The system acts like it does when we don't have a connection and try to
print a report. We also found numerous messages in the application log file
similar to the one below:

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

I checked the Connections tab on the Server Properties and it is set to 0
Maximum concurrent user connections (0 = unlimited)

Can anyone tell me where else can I look to figure out how to bump this
parameter up to remove this problem?

Thanks for looking at this.
Richard Sutterfield


Richard Sutterfield

2002-11-20, 3:23 pm

I think I found the problem. Looks like someone installed this using the
wrong CD and installed the Personal Edition. We are going to uninstall the
Personal Edition and install the Standard Version and see if our errors go
away. Thanks anyhow.


Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net