October 13, 2014 at 3:49 pm
Hi all,
I have a "select * into" process that is loading a table in schema A using data from another server. The problem is that this process blocks other processes that are trying to query (selects, inserts, etc.) the dbo schema. The wait_info for the blocked queries is showing a LCK_M_S wait type. I have googled and read some sites, but I am still not sure why queries against the dbo schema are being blocked and how to resolve it. Any help would be aprpeciated. Thank you.
October 14, 2014 at 2:28 am
LCK_M_S is not a schema lock, that's just a shared lock on a row/page/table. Sch-M or Sch-S would be your schema locks.
Can you post more details please? The exact resource being waited for as a bare minimum, the queries themselves are also near-essential.
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
October 14, 2014 at 3:39 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply