Post reply

Mutex in SQL

  • January 19, 2015 at 2:14 pm

    #397897

    Hi,

    I have the same application on multiple servers, I used application locks as mutex to serialize access at specific resources (sp_getapplock and sp_releaseapplock).

    Now sql server is configured in fail over cluster with another server, but for scalability problems I need to migrate to alwayson with primary node in read and write mode and the secondary node only in read mode.

    My problem is that application lock are not shared between nodes and then when connection is on secondary there are no locks.

    Are there any configuration at cluster or database level, or any workaround?

    Gianluca

  • January 19, 2015 at 2:39 pm

    #1771243

    kjed (1/19/2015)

    then when connection is on secondary there are no locks.

    be aware that when you enable a read only secondary in an AlwaysOn group, all isolation levels are automatically mapped to snapshot isolation, see this link.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 19, 2015 at 2:53 pm

    #1771247

    Ok thanks. I'll try

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

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