SQL Server 2000 Workload Governer

Workload governor limits the performance of MSDE if the SQL engine receives more load than limit of MSDE(8 Cuncurrent connection).

Workload governor sits between the client and the database engine and counts the number of connections per database instance. If Workload governor finds that the number of connections exceeds eight connections, it starts stalling the connections and slowing down the database engine.

It does not limit the number of connections but makes the connection request go slow. By default 32,767 connections are allowed both for SQL SERVER and MSDE.

No comments: