Hello All,
I have included few column in INCLUDE in my non-clustered index and while creating that with (ONLINE = ON , DROP_EXISTING = ON), I started seeing blocking issues. When I ran Whoisactive history script, I see a session which is below 50 (SYS SPID) is blocked by my index for 2 hours (I killed my index SPID after that) and that sys SPID is blocking other user sessions.
Once I kill index process everything is normal
Any suggestions to avoid this?
Version: 2017
