MARS performance articles needed

  • Thread starter Thread starter Marina Levit [MVP]
  • Start date Start date
M

Marina Levit [MVP]

Hi,

I'm trying to do research on the implications of using MARS, how it compares
to just taking advantage of connection pooling etc.

I'm looking for some actual articles/whitepapers, and so on.

Google has been very unhelpful in finding things specifically related to
performance and/or best practices. All I've found are examples and overviews
of what it is, which is not what I am looking for.

If anyone has any, please post, I would appreciate it.
 
I included a few pages in my new book on MARS and while my tests were not
particularly scientific, I found that it (generally) hurt performance. I
also found that it masked other issues like not closing connections. In this
case, instead of getting timeouts when the pool filled, I got a melt-down
after 10 connections had been opened.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Do you have any information which I can send out as links? I have to prove
this to others by handing them some links.
 
Marina,

I have excellent information on MARS in my book. If you are within the
united states, please contact me through my site
(www.winsmarts.com/contact.aspx), and I'll try and send you a free copy of
my book.

Angel Saenz Badillos had excellent information on MARS on his blog
(blogs.msdn.com/angelsb), but word of warning - some of that is Pre Beta2,
so it's out of date.

But he does talk specifically about performance.

In short, MARS *may* give you a tad bit better performance in very contrived
scenarios, but for most scenarios it is a more of a pain in the rear than
worth it. In fact, in many scenarios it will hurt performance. These
scenarios mostly all stem from the MARS overhead (session pools), or
transaction implications i.e. deadlocks, the upper limit of 10 sessions in a
session pool (and more than 10 = new connection = possibility of deadlocks =
ouchie)

If you need links right away, here are a few, but you'll have to
chop/slice/read a lot/apply the pre-beta2 correction:

http://blogs.msdn.com/angelsb/archive/2005/01/13/352718.aspx
http://msdn.microsoft.com/library/d...dn.com/angelsb/archive/2004/09/07/226597.aspx

Enjoy,

- Sahil Malik [MVP]
http://blah.winsmarts.com
 
Thanks for the info Sahil. The company I work for can definitely afford to
buy a book, but I appreciate the offer :)
 
Can I send you a list of books I need ;-). Okay just kidding.

Anyway, hope you found the rest of the links useful.

SM
 
Not really. I don't find a mention of this issue in my blog.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top