MS-SQL CPU limit

 ALTER RESOURCE GOVERNOR RECONFIGURE;

CREATE RESOURCE POOL pMAX_CPU_65
WITH (MAX_CPU_PERCENT = 65);
GO


CREATE WORKLOAD GROUP gMAX_CPU_65
USING pMAX_CPU_65;
GO


CREATE FUNCTION dbo.ClassifierFunction() RETURNS sysname
WITH SCHEMABINDING
AS
BEGIN
    DECLARE @workload_group_name AS sysname;
    IF (SUSER_NAME() = 'Permanent')
        SET @workload_group_name = 'gMAX_CPU_65';
    ELSE
        SET @workload_group_name = 'default';
    RETURN @workload_group_name;
END;
GO