Uwe Ricken
@sqlbambi.bsky.social
Data Addicted SQL Server expert.
International Speaker
Dad of two beautiful daughters….
International Speaker
Dad of two beautiful daughters….
Yep. A new Plan will be generated, IF the Optimizer detects changes in the statistics.
eg: create a table + Index.
Run a select to create a plan.
Rebuild the Index.
Plan is in the Cache.
Run the würd again and Check for recompile (xevent)….
eg: create a table + Index.
Run a select to create a plan.
Rebuild the Index.
Plan is in the Cache.
Run the würd again and Check for recompile (xevent)….
December 31, 2024 at 8:22 PM
Yep. A new Plan will be generated, IF the Optimizer detects changes in the statistics.
eg: create a table + Index.
Run a select to create a plan.
Rebuild the Index.
Plan is in the Cache.
Run the würd again and Check for recompile (xevent)….
eg: create a table + Index.
Run a select to create a plan.
Rebuild the Index.
Plan is in the Cache.
Run the würd again and Check for recompile (xevent)….
If statistics changed… the plan got obsolet but there is no FREEPROCCACHE for each Index rebuild :)
December 31, 2024 at 7:26 PM
If statistics changed… the plan got obsolet but there is no FREEPROCCACHE for each Index rebuild :)
Hi @aschenbrenner.bsky.social not sure what exactly you mean. But the blockers are in sys.dm_os_waiting_tasks and/or sys.dm_exec_requests.
Mabye that's what you are looking for?
Mabye that's what you are looking for?
November 24, 2024 at 9:22 AM
Hi @aschenbrenner.bsky.social not sure what exactly you mean. But the blockers are in sys.dm_os_waiting_tasks and/or sys.dm_exec_requests.
Mabye that's what you are looking for?
Mabye that's what you are looking for?
Next time I do. Good advice.
Thank you…
Thank you…
November 24, 2024 at 3:43 AM
Next time I do. Good advice.
Thank you…
Thank you…
Happy to see you both there…
November 23, 2024 at 8:59 AM
Happy to see you both there…