Microsoft SQL Server forum - Concurrent queries error

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

Concurrent queries error

Jeffrey Ehrhart via SQLMonster.com

2005-05-26, 11:23 am

On my server running SQL Server 2000 (SP3). I frequently get this
informational message in the Event Viewer log.

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

The application that I am running is a vendor application so I do not have
access to the code. I contacted the vendor, but they have never seen this
problem and cannot recreate it. I checked the Microsoft Knowledge Base for
help, but I came up empty. It seems like it should be a simple
configuration change.

Any advice?
Thanks,
Jeff

Jeffrey Ehrhart via SQLMonster.com

2005-05-26, 11:23 am

I found the answer many times by just searching this site. Should have
done that first.

Go ahead and remove this thread.

Jeff

Sponsored Links