Posts by Tara Kizer

I recently ran into a performance problem that had me scratching my head. How could a stored procedure’s plan have changed, and yet it not be reflected in sys.dm_exec_procedure_stats? So here’s what happened and what I knew: 7:45am: Users were complaining that a page was timing out 8:00am: Developer emailed the offending stored procedure and input parameter…