Post reply

Asynchronous transactions in SQL Server

  • August 17, 2009 at 12:47 am

    #213672

    Is there is a SQL server way of doing asynchronous transactions. we have a bunch of user activity recording SQL statements which run as and when a user hits a particular page.

    I was planning to put all this into a queue and have it processed asynchronously to avoide connection contention assuming an increased traffic.

    "More Green More Oxygen !! Plant a tree today"

  • August 17, 2009 at 1:55 am

    #1040046

    There's no asynchronous transaction feature. You can process commands asynchronously with a queue table and return controlo to the application as soon as you have populated the queue table.

    -- Gianluca Sartori

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

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