January 16, 2009 at 12:47 pm
Hi,
I have sql server 2000 server. My log file is full of following error,
"This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 3 queries and performance may be adversely affected"
can someone help, what is this about?how to fix it?
Thanks,
Usman
January 16, 2009 at 1:18 pm
usman.tanveer (1/16/2009)
Hi,I have sql server 2000 server. My log file is full of following error,
"This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 3 queries and performance may be adversely affected"
can someone help, what is this about?how to fix it?
Thanks,
Usman
No is not. You probably have MSDE or Personal edition which is actually designed with that limitation!
You probably need the Workgroup or Standard Edition ( Hopefully not Enterprise 😉 )
* Noel
January 16, 2009 at 2:47 pm
Thanks for the reply, Yes i have Personal Edition.
But what is this limitation all about? and why is this error occuring? and what will be happening (with sql server, and with queries, and with users) when this error occurs?
Does the only solution is to move to standard edition?
January 16, 2009 at 3:22 pm
usman.tanveer (1/16/2009)
Thanks for the reply, Yes i have Personal Edition.But what is this limitation all about? and why is this error occuring? and what will be happening (with sql server, and with queries, and with users) when this error occurs?
Does the only solution is to move to standard edition?
The Error is very explicit more than "8 concurrent queries" have been sent and you can have problems.
Apparently your application has outgrown the usage of it.
You either upgrade or reduce the number of concurrent queries.
You should try to upgrade Workgroup Edition which should be cheaper.
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply