InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Sql Server 2000 Work Load Governor? |
|
Answer» Workload governor limits the performance of SQL SERVER DESKTOP engine (MSDE). 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. Workload governor limits the performance of SQL SERVER Desktop engine (MSDE). 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. |
|