Hi, I have this message in the event viewer:
Event Type: Information
Can anyone tell me please how do you optimize SQL Server for a limited number of queries?
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 ♦♦
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
Robert L Davis