First published on MSDN on Jan 30, 2017
In SQL Server, when you perform a partition switch, a schema lock is acquired briefly to do the operation. This can get blocked by read operations that hav...
Updated Apr 28, 2020
Version 3.0
Blog Post
I'm using plain sql2019 not PDW but the result is equal a Sch-M Lock is raised shortly, even if no DDL is affecting the partition switch, I had to surround try/error logic with:
WITH (WAIT_AT_LOW_PRIORITY (MAX_DURATION = 5 MINUTES,ABORT_AFTER_WAIT = SELF))why not ask for a change in next CU/release ?
1. evalualte changes in partitions
2. raise Sch-M only if DDL changes are required