Does update stats lock the table?

• curious_sqldba

  SSC-Dedicated

  Points: 36502

  More actions

  March 12, 2011 at 9:50 pm

  #248182

  i have my update stats job running and i have query to find the locks . below is the output:

  MyDbNULLNULLOBJECTUPDSTATS8 3756723860XLOCKGRANT105100TRANSACTION3861649800000000-0000-0000-0000-0000000000000x00000000B7CCF760:2:10x00000001581B5540

  I see there is X lock on the object. I was told update stats doesnt lock the table? i am running update stats with full scan? Any thoughts?

• curious_sqldba

  SSC-Dedicated

  Points: 36502

  More actions

  March 12, 2011 at 10:45 pm

  #1298077

  sp_lock gave me this

  83756723860TAB[UPDSTATS] XGRANT

  83756723860TAB Sch-SGRANT

  83756723860TAB Sch-SGRANT

  how can the same update statement on the same table have X and Sch-S lock?