September 10, 2008 at 1:35 am
I'm running SQL Server 2000 on a Window 2000 server and getting the error below in the logs. Please could you let me know why it happens and what can solve the problem? Thank you
2008-07-30 16:06:15.49 spid12 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 12 queries and performance may be adversely affected.
2008-07-30 16:07:20.51 spid12 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 28 queries and performance may be adversely affected.
2008-07-30 16:08:25.48 spid11 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2008-07-30 16:09:25.51 spid13 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2008-07-31 16:32:26.46 spid12 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2008-07-31 16:35:51.49 spid11 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2008-07-31 16:36:51.50 spid8 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2008-07-31 16:53:26.57 spid8 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2008-07-31 16:54:31.57 spid11 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
September 10, 2008 at 2:06 am
It looks like you're running MSDE (the free SQL 2000 database engine). MSDE has a built-in throttle that limits it to a certain number of concurrent queries and you're exceeding it.
To check if it is MSDE, please run the following and post the results
SELECT @@Version
Otherwise, you can post the top 5 or so lines of the error log.
The only 'fix' for this is to buy a licence and install one of the other versions of SQL 2000 or 2005 (Standard edition possibly)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:17 am
The ran the statement in SQL Query Analyzer and the result is: Microsoft SQL Server ...
September 10, 2008 at 2:33 am
Please post the full result. Change QA to run to text, not to grid.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 4:21 am
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
September 10, 2008 at 7:04 am
That is MSDE, as shown by the last line 'Desktop Engine on Windows NT 5.1'
MSDE will slow down after 8 concurrent queries. It's an intentional throttling and there is no way around it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 7:09 am
What will help me fix the problem?
September 10, 2008 at 7:42 am
You'll have to buy one of the editions of SQL server. I don't know if you can still buy SQL 2000 though. Without knowing what you're doing, I can't say what edition, but standard edition is probably a good place to start.
Or you can get SQL 2005 express (free), it's limited to 2 GB databases and might be throttled as well (don't know offhand)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 7:51 am
Thank you!
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply