While analyzing our environment, I've noticed a recurrent blocking that usually happens around the same time, our monitoring tool says the blocked process is a "CREATE INDEX", however, the index maintenance is not in-progress when the issue arises. Looking at the details, the command seems to be running in the background.
Has anyone seen this background task before? I'd like to understand how/why this happens. I've looked it up and could not find much information.
I don't have automatic tuning enabled, also this is a small data mart, the ETL process doesn't include any index create statement. When I look at the blocking history, I can't really see what was the complete statement, it doesn't show plan handle or anything. I'm guessing it's an internal process as the SPID is below 50.