SQL Server 2008 Resource Governor - Ease Your Typing
Well...this is certainly not a normal post. This is a snippet of code for a SQL Server 2005 lab that I'm assisting with...if your in the lab, copy/paste. It will help with the lab "typing".
CREATE FUNCTION dbo.fn_ClassifyApps() RETURNS sysname
WITH SCHEMABINDING
AS
BEGIN
DECLARE @ret sysname
IF (APP_NAME() LIKE '%Low Importance Application%')
SET @ret='Low Importance Group'
RETURN @ret
END
GO
ALTER RESOURCE GOVERNOR
WITH (CLASSIFIER_FUNCTION = dbo.fn_ClassifyApps)
ALTER RESOURCE GOVERNOR RECONFIGURE
