As I dig deeper into the trace output, the selects are all under SQL:Batch and the inserts and updates come through RPC exec sp_executesql N'DELETE FROM.......' <p1 value>,<p2 value>

Does that make sense? Does it need to make a new execution plan each time the nonstop selects are happening? I see a new cache insert after each select. How about the sp_execute? Does that make a new plan each time? How does it all affect performance?