February 12, 2004 at 3:52 am
Hi all,
I am using MSDE 2000 SP3 and seem to have reached its limits. I get the following type of errors:
'This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 2 queries and
performance may be adversely affected.
The database then seems to slow itself down and this can make my application pause for up to 20 mins.
On the microsoft website their are two MSDEs to download: MSDE SP3a and MSDE 2000 release A, both of these say that their restrcitions are 5 concurrent workloads.
Does that mean that if I upgrade I will see an even greater loss of performance? Or am I missing a distinction between 'concurrent queries' and 'workloads' ??? Where are the other 3 queries coming from?
Besides upgrading to a full version of SQL Server, does any one have any ideas on how I could stop this deadlock?
The version of MSDE that ships with Sharepoint Services, seems to have is size restrictions removed, does any one know, if it has had its workload restrictions removed?
Thanks!!
February 12, 2004 at 10:06 am
1) MSDE 2000 SP3, MSDE 2000 SP3a, and MSDE 2000 Release A are all the same; Release A has a slightly different setup program.
2) All the MSDE releases (incl 1.0 (SQL7)) have the 5 concurrent queries limit. More than 5 queries, MSDE throttles execution by executing noop instructions; the more concurrent queries over 5, the more noop's.
3) The 3 extra queries counted in the "8 concurrent queries" message are for the sql engine processes.
4) The only way to greater than 5 queries is to purchase a full product (~$1400). You've exceeded what you can do for free.
5) Sharepoint's MSDE is exactly the same, with the same limitation. However, since all queries are run from the same connection settings (only one logon), it does use connection pooling, which may (likely) allow quicker and more efficient use.
Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply