TEMPOBJ

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

  1. 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

 

⇐ Back to index