Post reply

long rollback time with linked server

  • October 22, 2019 at 3:38 pm

    #3691040

    is the remote procedure being called with a 4 part name directly or by using OPENQUERY?  I try to avoid cross instance items where I can but I do try to stick to using OPENQUERY for remote objects.

  • October 22, 2019 at 3:51 pm

    #3691042

    It's 4 part naming - i'll give openquery a go - I've been playing with all sorts of techniques, but I've found that even if I Kill the spid half a second after starting the proc, it still takes 2 minutes to roll back/kill

    I've got a workaround for now

    I've set up a SQL agent job on the remote server, I just insert a record in a table and the remote server uses the sql agent job to call the stored proc on the remote server based on whether it is in the table or not  (it doesn't return any records)  (poor mans service broker) -

    our debugging works quickly now, but i'd like to figure out why the rollback is so slow

     

    MVDBA

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

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