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

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index