SQL Server Performance

Work load Governor

Discussion in 'Getting Started' started by khchaitanyaprabhu, Apr 19, 2007.

  1. khchaitanyaprabhu New Member


    I would like to know what is SQL Server 2000 Workload governor and
    it's functions ?

  2. satya Moderator

    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.

Share This Page