SQL Server 2008 Resource Governor - Ease Your Typing

  • Article

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