SET TRANSACTION ISOLATION LEVEL

  • Help! my server is running this process and causing it to drag, what is this, ANY BODY?

  • Isolation levels regulate how other users (processes?) can access data that you are accessing - like reading from a table for example.

    If your server is dragging maybe someone uses an isolation level that is unnecesserally high and thereby causing other users/processes to wait for access to a table.

    You can read about setting isolation levels in "Books Online" that comes with your server.

    Hope this helps you.

    /HL 

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

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