The configuration must follow the dependency chain of the Resource Governor architecture. First, create a resource pool to define the specific physical limits (CPU and memory) for App1. Second, create a workload group and map it to that resource pool; this group serves as the container for App1's queries. Third, create a user-defined classifier function that identifies sessions originating from "App1" (e.g., using APP_NAME()) and returns the name of the workload group created in the previous step. Finally, modify Resource Governor to register this new classifier function (ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = ...) ) and apply the configuration (ALTER RESOURCE GOVERNOR RECONFIGURE).

Microsoft Learn. (2023). Resource Governor. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor

Microsoft Learn. (2023). Create a Resource Pool. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/create-a-resource-pool

Microsoft Learn. (2023). Create and Test a Classifier User-Defined Function. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/create-and-test-a-classifier-user-defined-function

Microsoft Learn. (2023). Enable Resource Governor. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/enable-resource-governor