SQL Server 2008 :: Restrict Resources Usage Based On Individual Databases In Resource Governor?

How to restrict resources usage based on individual Databases in resource governor?

We have many databases in one instance; I would like to restrict resource usage to each database respectively.

I created 2 pools as pool_login, pool_DBNAME, and 2 workload groups as GroupLogin,GroupDBNAME, and also the classifier function.After setup above, I use following statement to check what sessions are in each group .

Even if there are spids which are accessing database DBNAME, I can’t see that they fall into the group GroupDBNAME and pool pool_DBNAME.

SELECT s.group_id, CAST(g.name as nvarchar(20)), s.session_id, s.login_time, CAST(s.host_name as nvarchar(20)), CAST(s.program_name AS nvarchar(20))
FROM sys.dm_exec_sessions s
INNER JOIN sys.dm_resource_governor_workload_groups g
ON g.group_id = s.group_id
ORDER BY g.name
GO

Following is the code to create pool, group,classifier function:

USE master
GO;
-- Create a resource pool pool_login.
CREATE RESOURCE POOL pool_login
WITH

[Code] ....

-- Create a workload group to use this pool.

CREATE WORKLOAD GROUP GroupLogin
USING pool_login;
GO
CREATE WORKLOAD GROUP GroupDBNAME
USING pool_DBNAME;

[code]....

-- Register the classifier function with Resource Governor.

ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION= dbo.rgclassifier_v1);
GO