Clear the cache while Stored Procedure session is running

Question

What happen if a SP A is running slowly with 5 different session ID (executed 5 times) and that point of a time, I clear the cache of that SP A or I execute sp_recompile for that SP A. Is it all the 5 session ID which is running SP A will start again with different plan or it's still executing using the same execution plan which previously it used before clear the cache ?

Answer 1

Is it all the 5 session ID which is running SP A will start again with different plan or it's still executing using the same execution plan which previously it used before clear the cache

Clearing a cache, in your case to be precise procedure cache, will not affect already running queries. When you execute a query it is compiled and plans are generated and the most cost effective plan is selected and stored, post this query is run by sql server based on the plan. Clearing the cache removes the plan but will not affect already running queries. But, a new SP execution request will now first create new plan and then run it.

Answer 2

Doing anything to the plan cache does not affect already running stored procs or queries.