Resource Governor
来源:互联网 发布:我的世界64位java 编辑:程序博客网 时间:2024/04/19 20:27
Resource Governor 可以将数据库负载根据用户要求,分散到自己可使用的资源中。从而限制不同的数据库访问程序可以使用的资源。
例如有两个程序app1和app2分别使用数据库。使用Resource Governor可以让app1只能使用1颗cpu和1G内存,app2可以使用3颗cpu和2G内存。
从而在程序层面上对其使用的资源进行监管。
主要的概念有:
Resource pools. Two resource pools (internal and default) are created when SQL Server 2012 is installed. Resource Governor also supports user-defined resource pools.
Workload groups. Two workload groups (internal and default) are created and mapped to their corresponding resource pools when SQL Server 2012 is installed. Resource Governor also supports user-defined workload groups.
Classification. There are internal rules that classify incoming requests and route them to a workload group. Resource Governor also supports a classifier user-defined function for implementing classification rules.
http://msdn.microsoft.com/en-us/library/bb933866.aspx
另外一篇参考文章:
http://msdn.microsoft.com/en-us/library/bb895389%28v=sql.105%29.aspx
在使用了Resource Governor后我们还可以使用以下SQL来查看各个group的负载情况。
-- use this to verify which sessions have the correct-- session classification.USE master;SELECT s.session_id, s.login_name, s.login_time, s.group_id, g.name as group_name,CAST(s.host_name as nvarchar(20)) as host_nameFROM sys.dm_exec_sessions AS s JOIN sys.dm_resource_governor_workload_groups AS g ON s.group_id = g.group_idWHERE session_id > 50ORDER BY g.nameGO-- Finds SQL Running in various groups --SELECT r.group_id, g.name, r.status, r.session_id, r.request_id, r.start_time, r.command, t.text FROM sys.dm_exec_requests rINNER JOIN sys.dm_resource_governor_workload_groups g ON g.group_id = r.group_idCROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS tORDER BY g.nameGO--Get specifics about the resource pools and workload groupsUSE masterSELECT * FROM sys.resource_governor_resource_poolsSELECT * FROM sys.resource_governor_workload_groupsGO--- Get the classifier function Id and state (enabled).SELECT object_name(classifier_function_id) AS [schema_name], is_enabledFROM sys.resource_governor_configurationGO
另外一个人写的浅显易懂的blog:
http://blog.sqlauthority.com/2012/06/04/sql-server-simple-example-to-configure-resource-governor-introduction-to-resource-governor/
和同一个人写的另外一个补充:
http://blog.sqlauthority.com/2012/06/09/sql-server-service-broker-and-cap_cpu_percent-limiting-sql-server-instances-to-cpu-usage/
最后是和resource governor 相关的动态视图。
http://technet.microsoft.com/en-us/library/bb895339(v=sql.105).aspx
- Resource Governor
- SQL Server2008 Resource Governor简介
- SQL Server2008 新特性 Resource Governor
- Handling workloads on SQL Server 2008 with Resource Governor
- SQL SERVER Resource Governor 自己翻译的白皮书(部分)
- Restricting IO Using SQL Server 2014 Resource Governor
- SQL案例--002--20110511--SQL Server 2008 R2 Resource Governor 的小 BUG
- SQL SERVER resource governor 来控制对于备份任务的资源消耗
- CPU调速器Governor说明
- powersave/performance governor study
- userspace governor study
- cpu_freq之切换governor.
- cpu_freq之注册governor.
- interactive governor study for android
- resource
- resource
- Resource
- Resource
- Kettle启动配置
- JAVA逻辑操作符测试
- SQL Server 安装时出现IIS功能要求警告的解决方法
- __init
- 多态的好处 例题介绍
- Resource Governor
- Resizable TitleWindow in Flex 4
- 关于过期数据的自动清理
- 计数排序
- Java assertion 介绍和用法
- linux虚拟文件系统
- 使用PUTTY配置端口映射
- 下载以及在线打开方式的方法
- man shc