Sql Server Clr Assembly Deployment Time

[Andy Jump]

Howdy all,

I have a Sql Server Assembly that contains some Clr stored procs for some of
the more complex operations I wish to perform. When the number of these
stored procs is low then the assembly deploys nice and quickly but as the
number rises the deploy time begins to take a huge amount of time.

Deployment took over 20 minutes for 167 stored procs.

I have done some checking and monitoring and found that it seems to be
visual studio that is taking its time and eating up a large amount of cpu
during the deploy.

Is there something I can do to speed this process up by changing settings?
Or would some sort of mechanism to make the stored procs, that can be, table
agnostic.

Many thanks

Andy

 

[Cowboy \(Gregory A. Beamer\)]

Make sure it is Visual Studio first. In the SQL Server Books Online, you can
look up the DDL to install the assembly and try from there. If that goes
quckly, it is an interface issue. If not, it is the actual install, even
though Visual Studio is consuming resources.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Andy Jump]

I've just tried installing the assembly manually and it went in faster than
Management Studio could measure.