• 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