• N.D (4/21/2015)


    This database doesn't have any create / drop table

    Weird. You shouldn't be seeing severe GAM contention in a user DB... If it happens again, can you capture the queries that are involved? It may shed some light on what's happening and why.

    Are you doing lots of data loads in parallel? (multiple sessions all inserting large quantities of data)

    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