#title Resource Governor
[[TableOfContents]]

==== 참고자료 ====
 * [attachment:ResourceGovernor/Using_the_Resource_Governor.docx Using the Resource Governor]
 * [http://www.sqlworld.pe.kr/mboard/mboard/mboard.asp?board_id=sql2008&group_name=board&idx_num=18&page=1&category=&search=&b_cat=0&order_c=idx_num&order_da=desc 리소스 관리자]
 * [http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1351616,00.html?track=sy41 Resource Governor primer]
 * [http://www.mssqltips.com/tip.asp?tip=1720 Handling workloads on SQL Server 2008 with Resource Governor]
 * [http://www.sqlservercentral.com/articles/Resource+Governor/64034/ Resource Governor]

{{{
--adhoc query를 위한 resource pool
create resource pool readeradhocpool
with
(
 min_cpu_percent=25, max_cpu_percent=50,
 min_memory_percent=25, max_memory_percent=50
)
go

--workload group to be used by reader login
create workload group readeradhogroup
    using readeradhocpool ;
go


use master;
go
create function dbo.resource_classifier() 
returns sysname 
with schemabinding
as
begin
	declare @workloadgroup as sysname
	
	if (suser_name() = 'reader')
		set @workloadgroup = 'readeradhogroup'
--	else if (suser_name() = 'reportuser')
--		set @workloadgroup = 'reportgroup'
	else 
		set @workloadgroup = 'default'

	return @workloadgroup
end
go

alter resource governor 
with (classifier_function=dbo.resource_classifier);
go
alter resource governor reconfigure
go
--alter resource governor disable
--go
alter resource governor reset statistics
go
}}}