开发者

SQL Server 2008 Resource Governor

开发者 https://www.devze.com 2023-02-15 18:11 出处:网络
What does the following function doing ? I am trying to create Resource Governor in SQL 2008 for A particular Host_name

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消