Post reply

strange schema blockings

  • July 24, 2012 at 11:47 am

    #264673

    wondering why the blocking report is showing the below statement as being blocked on the sql server on one of the user database:

    SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES

    It doesn't tell you any more. All the spids is displaying the same statement as being blocked by a leading blocker with:

    some create table and select inner join with the new create table and existing tables..All in a begin tran statement.

    There is a wait on Sch-S locks.

  • July 24, 2012 at 11:54 am

    #1516991

    The create table is the cause. That takes schema mod locks and those block absolutely everything.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2012 at 12:19 pm

    #1517012

    thank you. That confirms what I thought.

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

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