You may try upgrading it to 2.1, which has potentially those leaks removed.
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Mon, Jun 28, 2010 at 1:39 AM, Nikhil Desai <[email protected]>wrote: > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
