Ayende @ Rahien

Hi!
My name is Oren Eini
Founder of Hibernating Rhinos LTD and RavenDB.
You can reach me by phone or email:

ayende@ayende.com

+972 52-548-6969

, @ Q c

Posts: 18 | Comments: 63

filter by tags archive

Linq to Sql profiler – transactions

time to read 1 min | 127 words

Well, here is a new thingie, L2SProf can now detect transactions.

Both standard SQL transactions:

image

And also distributed transactions using System.Transactions:

image

This is an interesting feature, because you can see how the use of different transaction strategies have a big impact on how you structure your code.

For example, with L2S, it seems like you are encouraged to read outside of a transaction. Something that I, as an NHibernate user, find quite odd.


Comments

Samuel Jack

Ayende,

Amazing turnaround: I only asked for the feature 6 days ago! Thanks.

Can you take it a bit further? Can you provide a report grouping operations by their Isolation level. I'd like to be able to review everything that is working at Serializable isolation level to see whether it really needs to be that strong. I'm not quite sure how the report should be presented: perhaps it would need to be by method?

Dmitry

That's a helpful feature. I really like that it distinguishes distributed transactions, that for some reason seem to be very common in LINQ-to-SQL codebases, from database transactions.

On a slightly different note, could it be possible to have the Profiler to record ADO commands that are sent to the connection held by the data context?

Ayende Rahien

Samuel,

Interesting suggestion, I am not explicitly tracking this at the moment.

I've added an issue for this feature

Ayende Rahien

Dmitry,

Yes, it will track commands on the connection as well

Bart Czernicki

Nice product. Something I will definitely evaluate for our use, since we use Linq2Sql for read-only OR/M calls in several places.

You should add a link to the site on the related post(s) or on the side tab, since it took me a while to backtrack and try to find the Linq to Sql Profiler beta download site.

Comment preview

Comments have been closed on this topic.

FUTURE POSTS

  1. RavenDB 3.0 New Stable Release - 15 hours from now
  2. Production postmortem: The case of the lying configuration file - about one day from now
  3. Production postmortem: The industry at large - 3 days from now
  4. The insidious cost of allocations - 4 days from now
  5. Buffer allocation strategies: A possible solution - 7 days from now

And 4 more posts are pending...

There are posts all the way to Sep 11, 2015

RECENT SERIES

  1. Find the bug (5):
    20 Apr 2011 - Why do I get a Null Reference Exception?
  2. Production postmortem (10):
    31 Aug 2015 - The case of the memory eater and high load
  3. What is new in RavenDB 3.5 (7):
    12 Aug 2015 - Monitoring support
  4. Career planning (6):
    24 Jul 2015 - The immortal choices aren't
View all series

Syndication

Main feed Feed Stats
Comments feed   Comments Feed Stats