Tag Archives: how to find a sql_handle

Difference between sql_handle and plan_handle

After reading a post about DBCC FREEPROCCACHE with parameters, I got  a lot of question like What is sql_handle? what is plan_handle? How to find sql_handle and plan_handle? What is the difference between a sql_handle and plan_handle? Can we have a example to understand sql_handle and plan_handle ? Let me answer all these question, A [...]

Executing DBCC FREEPROCCACHE with parameters

DBCC FREEPROCCACHE, is used to clear all plan cache, which forces that every stored procedure will be recompiled  on it’s first execution to build a execution plan. This was known fact, till SQL Server 2005, DBCC FREEPROCCACHE has a server wide scope, means we can not clear a specific plan, this limitation was removed in [...]