Work load Governor | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Work load Governor

Hi.. I would like to know what is SQL Server 2000 Workload governor and
it’s functions ? Thanks
Workload Governor which limits the performance of the database system when more than 8 concurrent requests are made to the database. Notice that this is not the same as 8 users. It’s possible to have hundreds of users in OnTime and never have 8 concurrent requests to SQL Server – however, the likelihood of running into this limitation increases as the number of OnTime users increase. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.