Post reply

SP_GetschemaLock taking long time

  • October 1, 2008 at 2:05 am

    #194272

    Dear All,

    sys.sp_getschemalock procedure is executed againsts the master database by SQL Server and it is taking time to complete. if it is a internal process done by SQL Server then why it is executed by processes ID above 50.

    kindly clarifiy what is the purpose of this procedure and when SQL server will execute the procedure against the database.

    Thanks

    kokila K

  • October 1, 2008 at 3:47 am

    #879371

    sp_GetSchemaLock is a normal SQL Server internal sproc - it's used for data modifications to ensure atomicity. An sch-s lock is a schema stability lock - and it basically tells the engine that a query for this object is being prepared. An sch-m lock is a schema modification lock - an indication that a schema modification is about to take place.

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

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