Post reply

Help with Locks/ProcessID

  • March 4, 2003 at 4:15 pm

    #64910

    Within EM, under the Locks/ProcessID section of the Current Activity window, I see Lock Type = 'Ext'.

    According to BOL, this is a lock of "Contiguous group of eight data pages or index pages".

    Does anyone know what is causing this lock?

    The application that is accessing the database is only writing records to a single table.

    Thanks in advance,

    Billy

  • March 5, 2003 at 4:53 am

    #450302

    Is it updating a range of records. If so keep in mind a table lives on pages and if the range covers enough positions it may be locking the whole Extent to keep others from altering the data.

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

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