if Spotlight is the only thing monitoring the databases and the database have low activity, this is expected, the only way to avoid this alarm would be to turn it off(disable it from alarms setting for this SQL server).
Because Spotlight uses a lot of temp table, temp table can cause recompilation, This happens because temp tables are treated just like regular tables by the SQL Server Engine. When the tables (in which underlying queries rely on) change significantly, SQL Server detects this change (using auto update statistics) and marks the dependent queries to be recompiled so the next execution can create an optimal execution plan. A similar sort of phenomenon also happens in temp tables.
Spotlight only use very few resources in sql server, if the server was monitored by Spotlight only and no other use, this is expected.
You can just ignore this alarm(disable it from alarms setting for this SQL server)
