Re: Performance issues with NHibernate 3.1.0 -> oracle database

[Ricardo Peres]

I'd say it's impossible to tell without knowing the queries, the mappings, the configuration, etc... In your mail it's all very vague! :-)

RP

On Tuesday, May 21, 2013 3:32:29 PM UTC+1, Kim Bendtsen wrote:

We have a web application that is load balanced on 4 servers running on windows 2008r2 servers. The web application hosted on iis 7.* experience periodic bad performance where quries can take extra 1-60 seconds than expected.
Using nhprof and wireshark it seems possible to confirm the slow query results with the packet transmissions on the wire. I will try an attache an example, but the main flow is.

Client -> send query
Database->reponse
Client -> send ACK
15 seconds pass
Client -> send PSH ACK
Database -> response.

NHProf sees the query response.

We see many scenarios like this with different sleep intervals  - 1 to 30 seconds. Sometimes the client send the PSH Ack immediately.

Is this normal behaviour we are experiencing?
Where to start investigating further if this is a windows / network driver / iis / oracle driver / nhibernate issue?

Any advice or comments? 

Kr,

Kim

[Nuno Ramos]

I'm having the same problem. Did you found a solution?