What is SQL Server 2000 Workload Governor? | SQL Server Interview Questions

Workload governor limits performance of SQL SERVER Desktop engine (MSDE) if the SQL engine receives more load than what is meant for MSDE. MSDE was always meant for trial purpose and non-critical projects. Microsoft always wanted companies to buy there full blown version of SQL SERVER so in order that they can put limitation on MSDE performance and number of connections they introduced Workload governor.
Workload governor sits between the client and the database engine and counts 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.