December 11, 2001 at 10:17 am
We are on SS2K. In errorlog we are gettinig
"This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected."
Please advice me what have to do.
Thanks in advance.
December 11, 2001 at 10:37 am
Never seen this. Have you changed any settings? Is there an SP appplied?
I checked my errorlogs and this isn't in them.
Steve Jones
December 11, 2001 at 2:32 pm
Are you running the personal edition? Or MSDE? I saw a couple newsgroup postings that indicated this is the probable cause of the problem.
Andy
December 11, 2001 at 2:32 pm
Yes. We have applied SP2. We didn't change any settings. How can I check, the server is configured for, number of querries.
I tried with sp_configure, but is not showing about querris configuration.
December 11, 2001 at 3:03 pm
It is Enterprise Edition.
Satya
December 12, 2001 at 4:31 am
Could you run select @@version and post just to be sure?
Andy
December 12, 2001 at 8:43 am
I am sorry it is Personal Edition.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Thanks,
Satya
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply