Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MSDE 2000 (Desktop Engine) Concurrency Workload Governor

Posted on 2002-04-08
8
Medium Priority
?
664 Views
Last Modified: 2012-06-27
Hi,
I'd like to find out the exact concurrency limitations for SQL Server 2000 Desktop Engine (MSDE 2000). The Microsoft documentation refers to a 'concurrency workload governor' which increasingly degrades the performance of the machine when more than five workloads are executed concurrently. It states 'As more batch workloads are submitted beyond the five-workload limit, the concurrency governor continues to slow down the system.'

Does anybody know how this works? Is there any further documentation on this? Does the governor purposely slow the service down to 'punish' license misuse?

All suggestions welcome,

Anthony

PS - MS Documentation can be found at:
http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp
0
Comment
Question by:abirchall
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6926252
what I have read is exactly what you are descripting. MS does this to force companies to buy the SQL Server instead of using the FREE MSDE.
0
 
LVL 4

Expert Comment

by:TheSpirit
ID: 6926546
Well you get what you pay for ! Given MSDE has on real user interface, is limited in what replication it can use (and a number of other limitations - see Books Online) its not unreasonable. My understanding is that things get start to slow up after 5 users because there is a limit on the number of threads that can be used.
0
 
LVL 8

Accepted Solution

by:
chigrik earned 600 total points
ID: 6929022
MSDE doesn't limit the number of users who can connect to its database!

Check this link from Microsoft:
"Chapter 1: Understanding Microsoft Access 2000 Client/Server Development"
http://msdn.microsoft.com/library/en-us/dnapg/html/apg01.asp

>MSDE doesn't limit the number of users who can connect to its database,
>but it is optimized for five users. For a larger numbers of users, you
>should use SQL Server 7.0

See this article about MSDE vs SQL Server comparison.
"The comparison of MSDE 1.0 with SQL Server 7.0"
http://www.MSSQLCity.com/Articles/Compare/SQLvsMSDE.htm


With best regards,
Alexander Chigrik
http://www.MSSQLCity.com/ - all about MS SQL
(SQL Server Articles, FAQ, Scripts, Tips and Test Exams).
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:abirchall
ID: 6929073
Thanks for the info Alexander. Seems to be conflicting info from Microsoft as at the following location
http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp

it states:
MSDE "...has a managed concurrency workload governor that limits up to five concurrent batch workloads for optimal performance. Commands and log entries are available to monitor instances where more than five workloads are executed concurrently, a situation that can cause slower performance even on well-tuned systems. As more batch workloads are submitted beyond the five-workload limit, the concurrency governor continues to slow down the system. These workloads are not dropped or lost; they are still processed, but in an increasingly degraded performance mode. "

Do you think the reference to the "concurrency governor continues to slow down" merely is due to system performace rathar than embedded code to purposly slowing it down? If so I've picked them up wrong.

Thanks again,
Anthony
0
 
LVL 8

Expert Comment

by:chigrik
ID: 6929186
I am not sure, but suppose that Microsoft did not make something
to purposly slowing it down.
At least I heard that somebody made application based on MSDE
with 40 users!


With best regards,
Alexander Chigrik
http://www.MSSQLCity.com/ - all about MS SQL
(SQL Server Articles, FAQ, Scripts, Tips and Test Exams).
0
 

Author Comment

by:abirchall
ID: 6930764
I think it might also help to distinguish between MSDE 1.0 (based on SQL Server 7) and MSDE 2000 (or 2.0, based on SQL Server 2000).

All documentation on the concurrency governor is only mentioned in MSDE 2000.

MSDE 1.0 never mentioned this limitation but rather recommends a max of 5 concurrent users.

- Anthony
0
 
LVL 4

Expert Comment

by:TheSpirit
ID: 6930861
The 5 user limit is the number of threads that can they can run SQL on, if more users connect they will still use the same 5 threads but may need to wait until another user is idle before they can get access.
0
 

Expert Comment

by:CleanupPing
ID: 9280649
abirchall:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question