CLR integration gotchas!

I had recently enabled CLR and when the developer attempted to create an 
assembly, he encountered the following error:

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to 
memory pressure. Please restart SQL server in Address Windowing Extensions 
(AWE) mode to use CLR integration features.

While I was able to resolve this issue by restarting SQL Server using the -g 
option, I'm just wondering what other pitfalls, gotchas, etc. one should be 
aware of when enabling and using CLR integration. Does anyone know?

Thanks.
0
Utf
2/11/2010 4:18:01 PM
sqlserver.programming 1873 articles. 0 followers. Follow

3 Replies
703 Views

Similar Articles

[PageSpeed] 18

Hi Rob,

You've hit the main one. The others that people run into are:

1. SQLCLR only supports a subset of .NET libraries (that were tested and 
approved for use with SQL Server), the rest are technically unsupported. 
Certain functionality, even in the supported libraries (like using your own 
mutexes) are only supported when an assembly is cataloged as unsafe. Use of 
codegen (e.g. web services proxies generated on the fly at runtime) is not 
permitted.
2. CLR code is very good at procedural code, but slower than T-SQL when 
executing only SQL statements.
3. Individual appdomains can be recycled when SQL Server is running under 
memory pressure.

Hope this helps,
Bob Beauchemin
SQLskills

"Rob" <Rob@discussions.microsoft.com> wrote in message 
news:7EC85C32-F7C2-42DD-B7F2-2876AD2C140A@microsoft.com...
>I had recently enabled CLR and when the developer attempted to create an
> assembly, he encountered the following error:
>
> Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to
> memory pressure. Please restart SQL server in Address Windowing Extensions
> (AWE) mode to use CLR integration features.
>
> While I was able to resolve this issue by restarting SQL Server using 
> the -g
> option, I'm just wondering what other pitfalls, gotchas, etc. one should 
> be
> aware of when enabling and using CLR integration. Does anyone know?
>
> Thanks. 

0
Bob
2/11/2010 6:26:05 PM
get a copy of Professional SQL Server 2005 CLR Programming from WROX.

-- 
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Rob" <Rob@discussions.microsoft.com> wrote in message 
news:7EC85C32-F7C2-42DD-B7F2-2876AD2C140A@microsoft.com...
>I had recently enabled CLR and when the developer attempted to create an
> assembly, he encountered the following error:
>
> Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to
> memory pressure. Please restart SQL server in Address Windowing Extensions
> (AWE) mode to use CLR integration features.
>
> While I was able to resolve this issue by restarting SQL Server using 
> the -g
> option, I'm just wondering what other pitfalls, gotchas, etc. one should 
> be
> aware of when enabling and using CLR integration. Does anyone know?
>
> Thanks. 


0
TheSQLGuru
2/11/2010 9:37:49 PM
Very helpful, Bob. Thanks.

"Bob Beauchemin" wrote:

> Hi Rob,
> 
> You've hit the main one. The others that people run into are:
> 
> 1. SQLCLR only supports a subset of .NET libraries (that were tested and 
> approved for use with SQL Server), the rest are technically unsupported. 
> Certain functionality, even in the supported libraries (like using your own 
> mutexes) are only supported when an assembly is cataloged as unsafe. Use of 
> codegen (e.g. web services proxies generated on the fly at runtime) is not 
> permitted.
> 2. CLR code is very good at procedural code, but slower than T-SQL when 
> executing only SQL statements.
> 3. Individual appdomains can be recycled when SQL Server is running under 
> memory pressure.
> 
> Hope this helps,
> Bob Beauchemin
> SQLskills
> 
> "Rob" <Rob@discussions.microsoft.com> wrote in message 
> news:7EC85C32-F7C2-42DD-B7F2-2876AD2C140A@microsoft.com...
> >I had recently enabled CLR and when the developer attempted to create an
> > assembly, he encountered the following error:
> >
> > Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to
> > memory pressure. Please restart SQL server in Address Windowing Extensions
> > (AWE) mode to use CLR integration features.
> >
> > While I was able to resolve this issue by restarting SQL Server using 
> > the -g
> > option, I'm just wondering what other pitfalls, gotchas, etc. one should 
> > be
> > aware of when enabling and using CLR integration. Does anyone know?
> >
> > Thanks. 
> 
> .
> 
0
Utf
2/11/2010 11:31:01 PM
Reply:

Similar Artilces:

How to integrate excel worksheet in browser ?
Dear All, Please help !!! How to display excel worksheet in browser ? Showing Excel Worksheet Format on the browser. Thank you !!! Just navigate to the sheet , however note that this will only work correct if the client computer has office installed HTH Michel "Kelvin" <kelvinweb@gmail.com> schreef in bericht news:01c7e8e0-6e35-42fd-9e00-f89723a581a6@c37g2000prb.googlegroups.com... > Dear All, > > Please help !!! > How to display excel worksheet in browser ? > > Showing Excel Worksheet Format on the browser. > Thank you !...

POP Integration
About a month ago, I downloaded an adapter for Integration Manager 8.0 from Customersource so that I could integration purchase orders. I cannot find the download anywhere now. Can someone point me to where it is? ...

Integration Manager Translation Table
He have an integration that's currently using a translation table for one of the fields in Destination Mapping. We're changing our import file so we no longer need the translation. How do we remove the translation? I can't change the value from Yes to No. Do I have to delete all the values in the table? Go to the rule properties for the translation, highlight the "Yes" then press delete. You'll be asked if you want to delete the transaction. "Elaine" wrote: > He have an integration that's currently using a translation table for one of &g...

integrating .wav to text s/w in mfc #2
Hi friends, I want to integrate wav to text converter in my application,can any body help me which API or fuctions in mfc that I can go for thanks, rajendra ...

Integrating with outlook and exchange
Hi all, I want to apologize if this is the wrong forum for this question. I would like to write an application, in Java running on UNIX, that would insert, read, and mark as completed tasks in exchange. What is the best approach for this? Is the answer to write a web service using C# and then call it from Java? Does OWA already provide a set of web services for something like this? If so is there WSDL to go with it? Also, does exchange allow a super user to do this on behave of someone else, or do you need to have individuals logins. If the java app and Exchange both share AD/LDAP doe...

Small Business Financials Integration?
We currently use Quickbooks as our accounting package, but we have outgrown it. We are looking at switching over to SBF in 2007 and I was wondering what kind of integration to expect with RMS. Is anyone using this combo right now? Any thoughts? This is a multi-part message in MIME format. ------=_NextPart_000_0023_01C6A9E2.9F71B490 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Stringers, The people that I know that have tried the RMS->SBF are not real happy. = ;-( Maybe next year MS will do more with SBF, this past year they&#...

Integration Manager read only
I'm trying to set up the integration manager so that a user can only run the integrations and not modify them. I tried setting the IMD File to read only. That just creates an error message every time it runs. Anyone know how to set it up with out having the message appear and prevent the users from change the IMs? Thanks You could remove the integration manager (impath) from the dex.ini and allow only the Run Integration application (IMExecPath). You could also remove security rights to the Integration Site Enabler for the user in System security setup "dgindy&qu...

License Integration
Hi, Does anyone know if two, seperate, single lane licenses will be able to access the same DB at the same time? Thanks in advance, Pete If it is version 2.0 YES. If it is older versions NO. Afsin Alikhani - [ afshin@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = = = "Pete A." <PeteA@discussions.microsoft.com> wrote in message news:A6FF89C9-9438-4234-9D15-A410A7A357EC@microsoft.com... > Hi, > > Does anyone know if two, seperate, single lane licenses will be able to > access the same DB at the same time? > > Thanks in advance, > > Pete ...

Field Service modules integrated to PDAs
We have field service modules (service call management, RMA, RTV) implemented on Great Plains 8. What options do I have so that our field technicians access this information (read or inquiry capability) over say PDA. I am looking for Microsoft and ISV options. FieldConnect's FieldACCESS solution provides this capability. For more information contact me at 949-428-1540 or c.wawrina@fieldconnect.com. Carl Wawrina FieldConnect, Inc. "Jack Tundra" wrote: > We have field service modules (service call management, RMA, RTV) > implemented on Great Plains 8. What option...

Moving the Biztalk integration to new hardware
Running CRM 1.2, GP 7.5 sp4, Biztalk sp 1 with integration, all on Win2k SP4. All on separate servers. There are a few customizations done in CRM but no custom fields that are mapped to GP. Any one have any experience moving the BizTalk piece to a new piece of hardware? Can't find any white papers or much information at all on how to get this done without losing the current set up. Many thanks I have logged similar support incidents with MS. To date they have not been able to provide any information. "Jeff Metcalf" <JeffMetcalf@discussions.microsoft.com> wrote in ...

IM integration with CRM 3.0
-- Paul Croubalian VAR Sales - North America PARTpoint Inc ...

Integration Manager and Salesperons
Hi all, Just wondering if it is possible with integration manager to upload (change ) sales invoices salsperson recorded in SOP30200. I tried with PSTL Salesperson modifier tool but i wan tto change SOP records of the current year. I really appreciate your help and your suggestions regarding this manner. I do not think there is a way to change the salesperson on a posted invoice from the user interface. "erasmom" wrote: > Hi all, > > Just wondering if it is possible with integration manager to upload (change > ) sales > invoices salsperson...

integrate web page form with sql and crm
Is it possible to edit the "case" form using front Page. If so how do i set it up to access the sql database. These forms are not designed to be edited in frontpage. "Dana" <anonymous@discussions.microsoft.com> wrote in message news:e28701c3f0e5$21e37e40$a101280a@phx.gbl... > Is it possible to edit the "case" form using front Page. > If so how do i set it up to access the sql database. ...

How to determine the area under a curve (integration) in Excel?
I would like to compare the areas under curves in a chart. How to determine the area under a curve (integration) in Excel? Hi, Have a look at Bernard Liengme's page. http://people.stfx.ca/bliengme/ExcelTips/AreaUnderCurve.htm Cheers Andy Hawkeye wrote: > I would like to compare the areas under curves in a chart. > > > > How to determine the area under a curve (integration) in Excel? ...

Integration Manager
Hi All I'm working on an integration to take an invoice and its line items from an SQL DB to GP10. I all the header and line item detail in the sales transaction OK. The integration fails at the end with a message: "you are not allowed to delete this document". If I click Ok and click Save, I get another message: "Account is empty. Do you want to save chenges with errors?" ...

Integration Manager and Analytical Accounting
Does the latest service pack (4 )of IM import data that is entered to GL also in analytical Accounting tables? Is there a data file format available? Any information to this respect will be greatly appreciated. thanks. -- Patti Patti, You can import data into AA tables with IM if using the eConnect Adapter. As for format, you need to have four source queries, as follows: Transaction Header |_Entries |_Analytics |_Dimensions NOTE: All data may reside in one file, but you will need to have source queries to achieve the relatioship (1 to Many) needed for IM to...

MS Project 2003 Clarity Integration Field Mapping
I am using MS project 2003 with full Clarity integration and noticed that there is a neat field available when you use the Workbench scheduling tool - Pending Time Entry. Does anyone know how I can get the field/column mappings between MS Project 2003 and Workbench when integrating with Clarity? ex. in Workbench ETC is the same field as Remaining Work in MS Project 2003. What about all the others??? ...

Integration Manager
Is there a way to create a reversing GL JE in IM? I see a field to put the reversing date but it doesn't do anything. Seems like I must be missing a step. Thanks. OOOPPPPS! This Q was already posted and answered. Sorry. "patfinn_98" wrote: > Is there a way to create a reversing GL JE in IM? I see a field to put the > reversing date but it doesn't do anything. Seems like I must be missing a > step. > > Thanks. ...

Integration with FoxPro
Hi there My customer is having his inventory & invoicing system in a FoxPro system. Is it possible that using SDK, I can populate and update the FoxPro data from my MS-CRM pages Pls advice -- Regards Parasuraman Yes, its posible -- Alex�nder Osorio Business Intelligence Specialist Caracas - Venezuela "Parasuraman" <parasu78@yahoo.com> escribi� en el mensaje news:036401c4f874$06c31700$a401280a@phx.gbl... > Hi there > > My customer is having his inventory & invoicing system in > a FoxPro system. > > Is it possible that usin...

integration
I have Office Professional. I'm a new user who wants to use Word to create my template forms and reuse them. I'm trying to find out if there is any combination of Office tools that I can integrade with Word that would permit me to add data to one field on the form while the same data is being added to other fields on the same form. I don't want to cut and paste and I also want to reuse my template form. Is there any office tool or combination of tools that I can integrade with Word to fulfill my tasks? Yes, but it's hard to be specific without understanding more ...

Payables transaction file and integration manager
2007 Sep 16 I want to use integration manager to import data from another application to enter payables invoice transaction data. Information will be required for: PM10100 PM Distribution Work File PM10500 PM Tax Work File PM10000 PM Transaction Work File Please let me know if this is correct. Thanks, Jacqueline Chay ...

Integration to Siebel
Has anyone integrated Siebel 7.7 Order center to Great Plains order management? what was the duration to build the integration? ...

Integration -- best practice for ERP / CRM cross references
Greetings, I'm implementing some integration points between MS CRM and an ERP application, MFG/PRO. I've had good luck with Accounts and Products. I've also successfully created an invoice. The invoice poses a bit of challenge in that one cannot assign an invoice number to a CRM invoice. Ideally, I'd like the <invoicenumber> field of the Invoice object to equal the invoice number from the ERP system. Unfortunately, CRM wants to assign its own invoice number. I don't see another field on the Invoice object that fits the bill. This isn't the end of t...

Excel/Outlook integration
This is a tricky one hopefully someone has a suggestion. We're trying to implement a better system of management for our library at work. I have two questions for this 1: I'd like Outlook to send a mail automatically after four weeks if the book/cd hasn't been returned. (I think this will require integration with Excel, but I'm not sure how to do this 2: If I receive no e-mail response to that mail within 3 days I would like Outlook to send another "reminder". I'm sure this must be possible. We have Office 2000/XP/2003 rofessional at our disposal (XP is more com...

Using account aliases in GL integrations
We are on GP 8.0 and trying to integrate a general journal using the account alias instead of the account. The General Journal destination does not have an Alias field. The only place I can find the Alias is in the Account destination. You should be able to add a translation to your integration to cross-reference the account alias to the right account. -- Jim@TurboChef "gmontgomery" wrote: > We are on GP 8.0 and trying to integrate a general journal using the account > alias instead of the account. The General Journal destination does not have > an Alias field...