Concurrent queries

[jaylou]

Hi All,
I have a lot of scheduled jobs that run many stored procedures. Some procs do not seem to be working properly, but I am not getting any error messages.
I just checked the event log on my server and there are information messages that say:

The SQL server has been opitmized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversly effected.

Is there a setting that I can alter to expand this to either unlimited or at
least 20?
TIA,
Joe

 

[JamesLean]

In EM, right-click the server and go to Properties. Change the value in the Connections tab.

--James

 

[jaylou]

Thanks, I already have it set to 0 for unlimited.

Joe