SQL Server Performance

Resource Governor

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by hitmanus, Oct 23, 2007.

  1. hitmanus New Member

    Using this, we should be able to set usage of CPU and stuff like this.
    So, what do you think about it?
    Peter
  2. satya Moderator

    Yes very useful for DBA and you can easily gain control of your multiple workload environment by defining workload prioritization, limit known large workloads from abusing resources, minimize the possibility of runaway queries and provide mission critical workloads with the resources they need.
  3. hitmanus New Member

    yes, I wonder how difficult it will be - to set all these thing.
  4. satya Moderator

    I don't see any. download CTP version and look at the SQL 2008 Books ONline for more information.

Share This Page