0

Is it a good-practice to enable SQL Server CLR integration in a server-cluster scenario? The policy at my organization disallows deploying CLR assemblies on their production servers; I was informed by the DBA's this is because the CLR UDFs runs in-process and the databases are on a cluster.

I'm just curious if the policy is to simplify the DB admin (and perhaps ensure all code is open for review by DBA's), or is there a technical reason to prohibit CLR integration in a server-cluster scenario? Thread safety?

Related questions:

(By the way, my primary use-case is for string-manipulation UDFs, as described in this answer)

Community
  • 1
  • 1
wingmsr
  • 5
  • 1
  • 1
  • 5
  • Also found [this](http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/celko-on-sql-clr-database-design-is-a-totally-different-skill-from-application-development.aspx). – wingmsr Mar 31 '12 at 16:32

2 Answers2

1

afaik there is no correlation between a clustered sql server instance and the CLR integration. SQL Server acts as a CLR host. When CLR functionality is used (e.g. calling a CLR UDF) the assembly is loaded from the database. A passive cluster node does not have SQL Server service started so why should it bother? An active/active cluster will have two SQL Server instances running which are independent from each other. One is active on node one the other one on node two.

Well, with unsafe assembly code you can surely cause issues and bring down a sql server instance (and make it failover back and forth in a clustered environment). DBAs not necessarily have a clue of .net programming and probably want to avoid dealing with such problems. Otherwise I would see no solid reasoning behind this policy that would stand technical argumentation. Just be careful about what code you want to run on SQL Server. There is definitely a reason behind the security gates for CLR code (safe, external_access and unsafe).

Cheerio

BahamasWilli
  • 26
  • 1
0

Here I have posted an article why and when we should use CLR integration [http://www.queryingsql.com/2013/08/net-components-integration-with-sql.html][1] http://www.queryingsql.com/2013/08/net-components-integration-with-sql.html

queryingsql
  • 1
  • 1
    Note that [link-only answers are discouraged](http://meta.stackoverflow.com/tags/link-only-answers/info), SO answers should be the end-point of a search for a solution (vs. yet another stopover of references, which tend to get stale over time). Please consider adding a stand-alone synopsis here, keeping the link as a reference. – kleopatra Aug 31 '13 at 12:35