-
Re: SQL Server System Common Language Runtime (CLR)
qle Jun 11, 2009 6:54 PM (in response to thurgoodj187)See if the following knowledge base article helps:
-
Re: SQL Server System Common Language Runtime (CLR)
tkelly Jul 15, 2009 4:14 PM (in response to qle)I have a follow-up post to this. Is it in an official document somewhere stating that CLR is required. We run our system on a consilidated Enterprise SQL server also and our DBAs have intentionally not installed CLR and are fighting the installation of CLR. At this point I'm stuck where I can't upgrade. I'm hoping maybe the document will go into why it's required and what benefits we will see from it.
-
Re: SQL Server System Common Language Runtime (CLR)
Andy McBride Jul 15, 2009 4:36 PM (in response to tkelly)The Orion NPM Administrators Guide calls out the requirement in the System Requirements section.
http://www.solarwinds.com/support/orion/orionDoc.aspx
There are a number of references out on the web regarding the benefits, but they all are written in DBA talk. For Orion, CLR allows for improved performance.
Andy
-
Re: SQL Server System Common Language Runtime (CLR)
Debbi Sep 8, 2009 10:34 AM (in response to Andy McBride)In the release notes for 9.5 it says: If SQL Server System Common Language Runtime (CLR) Types are not already installed, Orion NPM will install them.
I upgraded but did not get any error message, and here I have been running on 9.5 for several weeks not knowing that CLR is not enabled. It was only when I tried to edit custom properties that I had a problem! I am scheduled to enable CLR on Thursday AM and was told to run the Wizard after the SQL server reboot. I hope that will be sufficient and I will not have to reinstall. What else in 9.5 relies on CLR that may be broken and I just have not noticed???
Debbi
-
Re: SQL Server System Common Language Runtime (CLR)
John.Taylor Sep 8, 2009 11:03 AM (in response to Debbi)CLR is also used by the config wizard to setup a couple of database maintenance scripts for wireless, energywise, and Netflow's CBQoS. If these scripts are not correctly generated and you use any of these features, then your database tables will grow very large very quickly.
John Taylor
-
Re: SQL Server System Common Language Runtime (CLR)
Debbi Sep 8, 2009 12:15 PM (in response to John.Taylor)Thanks. I hope running the wizard will be sufficient, and I will not have to reinstall.
-
Re: SQL Server System Common Language Runtime (CLR)
John.Taylor Sep 8, 2009 12:41 PM (in response to Debbi)I believe that it will be
-
-
-
-
-
-