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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

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

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