I've been trying to configure / troubleshoot the resource governor on a sql server 2014 instance. I can't get any work into anything but the default resource pool. I've been following this troubleshooting guide: http://technet.microsoft.com/en-us/library/cc627395(v=sql.105).aspx
My classification function, originally conditional, now simply returns my resource pool name in all cases in an attempt to get something to run in it.
USE [master] GO /****** Object: UserDefinedFunction [dbo].[RGClassifier] Script Date: 7/25/2014 7:26:51 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[RGClassifier] () RETURNS sysname WITH SCHEMABINDING AS BEGIN DECLARE @GroupName SYSNAME SET @GroupName = N'in-memory' RETURN @GroupName END
Results of some of the troubleshooting follow:
USE master SELECT object_schema_name(classifier_function_id) AS [schema_name], object_name(classifier_function_id) AS [function_name] FROM sys.dm_resource_governor_configuration
schema_name function_name dbo RGClassifier
Queries of sys.dm_resource_governor_configuration and sys.resource_governor_configuration indicate it is enabled and no reconfiguration is pending.
More or less stuck in the mud at this point. If anyone has configured the resource governor successfully before I'd love some pointers.