SQL Server Performance Forum – Threads Archive
Work load GovernorHi.. 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. http://msdn.microsoft.com/library?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true
http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx 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.