Hi I am using Nhibernate version 1.2 for one of our major production application. My application is a .NET 3.5 WCF based web service and I am using Oracle 10g Database. The web service is being consumed by all most all major airlines across USA and across the globe. We provide travel insurance on the airlines web sites to the airlines customers. On an average we received around 1.8Millions requests in a day to the web service. I have four powerful virtual instances each with Quad core processor and 8GB RAM and they are hardware load balanced. I am running Web Services on IIS 6.0 with .NET Framework 3.5 runtime.
Recently we are finding issues in the production environment where the IIS worker process memory usage goes sometime 100% causing web service not to perform well or mal-performed. I took the IIS crash memory dump and analysed it. It seems MSCORELIB.DLL is consuming most of the memory and one of the issue is Load SQL. Since my web service is only using NHibernate to do a communication with Oracle Database, I believe Load SQL method is part of NHibernate 1.2 and it is consuming lots of memory. I am right now refactoring code, and while going through lots of interesting articles, I came across one article where it was stated that NHibernate caches all the SQL statement that it generates and it leads to a huge memory leak. What I would like to know is, are there any configuration changes that I can make to ensure that NHibernate 1.2 is not caching all the SQL statements? and also is there a way by which I can completely stop caching SQL statements being cached. I know the properties Cfg.Environment.UseQueryCache="false" and CacheProvider=NoCacheProvider.But I have read articles on this as well where developers have complalined about this does not prevent NHibernate from caching SQL statements. Like I said my application is highly used 24X7 and it generates lots of revenue for my employer (in tune of $500Millions) so your help will be greatly appreciated. Do you think is there anything else I need to take care in terms of NHibernate not causing any memory leaks? if you have any ideas on preventing memory leaks with NHibernate version 1.2 please do share it with me. please let me know your suggestion/recommendation Thanks and Regards Nikhil Desai Lead Architect -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
