Session

The Case of the Slow Temp Table: A Performance Tuning Problem

A community member sent me an interesting question: why would using a temp table cause a stored procedure to slow down dramatically? Why would the procedure use massively more logical reads against a temp table than it does against a user database table? In this session we reproduce the problem, then use built-in tools in SQL Server to diagnose and understand what is happening. We use the results to make a plan to keep the stored procedure fast.

Kendra Little

Consultant and Cartoonist

View Speaker Profile

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top