Post reply

Find additional connection parameters with DMV

  • February 6, 2014 at 5:22 am

    #303785

    Hi,

    is it possible to get additional connection parameters of connectionstrings like MultiSubnetFailover = true

    for open connections with Dynamic Management Views?

    Or with Extended Events/SQL Profiler?

    thanks,

    Alex

  • November 28, 2017 at 3:52 am

    #1969655

    Hi,
    I've got the same question and to my opinion the additional connection parameters are a SQL Server *client* thing - the server isn't aware of these settings ...
    Anyone other ideas?
    TIA,
    Karsten

  • November 28, 2017 at 4:59 am

    #1969660

    Plan affecting settings are stored inside the execution plans. However, everything else is through standard events like existing_connection. It lists a lot of stuff, but not the subnet failover setting.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply