Any performance hit with MultipleActiveResultSets=True? RRS feed

  • Question

  • Does anyone know if using MultipleActiveResultSets=True when you don't need to be will cause a performance hit?


    I am not sure if I should have two connection strings and only use the multiple connection string when I need to or if it is OK to just have one with MultipleActiveResultSets=True and use it for everything.

    • Edited by Chomsky Monday, May 24, 2010 7:18 PM mistyped
    Monday, May 24, 2010 7:18 PM


  • Yes, it is documented as having "additional overhead", but so does the alternative of having multiple connections / transactions.

    A quick search of the 'net didn't reveal any major performance complaints.  You'll probably be okay.



    When a connection is opened with MARS enabled, a logical session is created, which adds additional overhead.



    • Marked as answer by Chomsky Tuesday, May 25, 2010 1:49 PM
    Tuesday, May 25, 2010 12:13 AM