Answer
Hotspots occur when many inserts hit the same index page (e.g., identity keys). They cause blocking and contention.
Quick Answer
Hotspots occur on the last page of a sequential clustered index (identity or timestamp key) when many concurrent inserts all target the same page. They compete for the same page latch, serializing inserts. Solutions: GUID clustered key (random distribution), multiple tempDB data files, or table partitioning.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ