I have no maintenance plans yet I see indexes being created in the background (low spid). I have no idea what indexes are being created or why. Using Standard SQL Server 2017 - a VM on Azure with SQL Installed.
I checked and did not see anywhere with automatic index management. You can configure backups, etc. but I cannot find a spot for indexing.
EXEC sp_WhoIsActive @show_system_spids = 1; and got this result:
I think what is happening is I have a "messed up index" and the system is trying to fix it. I cannot drop the index whatsoever or rebuild it. At least that is my guess.