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
Wednesday, August 27, 2025
MS-SQL CPU limit
Subscribe to:
Post Comments (Atom)
Fiber cable colours
هل تساءلت يومًا كيف يميز الفنيون والمهندسون بين مئات شعيرات الفايبر الدقيقة داخل كابل واحد؟ السر يكمن في نظام دقيق وموحد عالميًا يُعرف بـ ...
-
Allow AutoCAD License Check on FortiGate Identify the Licensing Server URLs and Ports Used by AutoCAD Autodesk’s licensing servers requir...
-
Run CMD as administrator cd "C:\Program Files\Microsoft Office\Office16" cscript ospp.vbs /sethst:kms.digiboy.ir cscript ospp...
-
Testing the DNS To test if your DNS can reach FortiGuard, use the following CLI command...
No comments:
Post a Comment