Description
This is a rare wait type. It accumulates when users are trying to access global temporary while it is being dropped elsewhere. Minimal values are acceptable but should be investigated
Resolved by
Developers
Suggested solutions
- It is generally best coding practice not to use global temporary tables as their behaviour can be non-determinist. Consider converting to regular temporary tables or a staging table
Additional research
Temporary Tables: Local vs. Global
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device