i think i confused you. i did not set a min memory for DBCC pool. here are my pool settings for DBCC and APP pools:
CREATE RESOURCE POOL [DBCCMaint]
WITH (min_cpu_percent=0,
max_cpu_percent=100,
min_memory_percent=0,
max_memory_percent=10,
cap_cpu_percent=100,
AFFINITY SCHEDULER = AUTO);
GO
CREATE WORKLOAD GROUP [wg_DBCCMaint]
WITH (group_max_requests=0,
importance=Medium,
request_max_cpu_time_sec=0,
request_max_memory_grant_percent=25,
request_memory_grant_timeout_sec=0,
max_dop=0)
USING [DBCCMaint];
GO
my classifier func:
-- APPPOOL:
CREATE RESOURCE POOL [APPPool] WITH(min_cpu_percent=70,
max_cpu_percent=100,
min_memory_percent=70,
max_memory_percent=100,
cap_cpu_percent=100,
AFFINITY SCHEDULER = AUTO
)
GO
-- Classifier Func:
ALTER FUNCTION [dbo].[Fn_RGClassifier]()
RETURNS SYSNAME
WITH SCHEMABINDING
AS
BEGIN
DECLARE @WorkloadGroup SYSNAME
IF (SUSER_SNAME() IN ('DOMAIN\APPUser'))
SET @WorkloadGroup = 'APPGroup'
ELSE IF SUSER_NAME() IN ('DBCCUser')
SET @WorkloadGroup = 'wg_DBCCMaint'
ELSE
SET @WorkloadGroup = 'default'
RETURN @WorkloadGroup
END