Envobi
QlikView Consulting
  • Home
  • Blog
  • Subscribe
  • Contact
You are here: Home / plan_handle

plan_handle

GOTCHA: SQL Server changes query plan without changing plan_handle

GOTCHA: SQL Server changes query plan without changing plan_handle

By Kristian Wedberg on April 11, 2011

Or how to efficiently get at old query plans Performance Tuning Mission While on a SQL Server 2008 Data Warehouse performance tuning mission, this aspect (or undocumented gotcha as it felt like at the time) of the query plan Dynamic Management Functions caused some head scratching, until I sussed that: A query plan can change […]

Posted in SQL Server | Tagged DMF, DMV, Dynamic Management Function, monitoring, Performance, plan_handle, query plan, sampling, SQL Server, SQL Server 2008 R2, T-SQL | Leave a response

Tags

.Net AJAX ZFC C# Chart Code First Data flow DMF DMV Dynamic Management Function EF ETL Horizontal Hyper-Threading Issue LINQ monitoring ORM Performance plan_handle QlikView query plan sampling SMO SQL Server SQL Server 2008 R2 SSIS T-SQL Test data VirtualBox Windows

RSS Recent blog posts

  • VirtualBox Hyper-Threading Benchmark Surprise
  • Tip: Open QlikView Without Data in Windows Explorer
  • QlikView Horizontal Table Issue with +40 Fields
  • SMO + LINQ for Entity Framework Code First Database Modifications
  • GOTCHA: SQL Server changes query plan without changing plan_handle

Log in
Copyright © 2019 Envobi