1) update to NH2.1.2 (NH1.2 with .NET3.5 is simply a crazy choice) 2) be sure you are using a good pattern to manage the session (for WCF session-per-call or session-per-request if webservice) 3) Hi hope you are not using HashTableCacheProvider 4) NH does not cache query results is you don't explicitly ask for it
On Sun, Jun 27, 2010 at 7:39 PM, 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. > > -- Fabio Maulo -- 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.
