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,
PS - MS Documentation can be found at: