Nh prof discover opened transactions with no statements that takes 4 seconds

17 views
Skip to first unread message

Haim Rozenblum

unread,
Dec 24, 2014, 11:26:06 AM12/24/14
to nhp...@googlegroups.com, Yair Kuszpet, ofer....@zerto.com, shlom...@zerto.com, Omri Shefi
Hi,
I am newbie with Nh-Prof.
I run it on our big scale environment and I saw that there are empty transactions - transaction.begin and transaction.commit with no statements that takes more than 4 seconds.

I see the following:
-- statement #1
begin transaction with isolation level: Unspecified

-- statement #2
commit transaction

We know the an empty transaction is a bug but we are concerned that it hides other bugs.

What can be the reason for this?

Thanks,
Haim.

Capture.PNG

Oren Eini (Ayende Rahien)

unread,
Dec 24, 2014, 11:34:17 AM12/24/14
to nhprof, Yair Kuszpet, ofer....@zerto.com, shlom...@zerto.com, Omri Shefi
Do you have abandoned sessions? 
Look at the stack traces for this

Hibernating Rhinos Ltd  

Oren Eini l CEO Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 


--
You received this message because you are subscribed to the Google Groups "nhprof" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhprof+un...@googlegroups.com.
To post to this group, send email to nhp...@googlegroups.com.
Visit this group at http://groups.google.com/group/nhprof.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages