SQL Server 2008 Resource Governor
What does the following function doing ?
I am trying to create Resource Governor in SQL 2008 for A particular Host_name
CREATE FUNCTION fnHostClassifier()
RETURNS sysname
WITH SCHEMABINDING
AS
BE开发者_如何学JAVAGIN
RETURN host_name()
END
GO
the host_name function returns the workstation name. The sql you have creates a UDF that does that.
You can read up on it more here.
If you are trying to work with the Resource Governor, I'd say you're looking in the wrong spot. Start by doing some reading here.
精彩评论