Answer
Causes include:
- Large memory grants
- Hash and sort operations
- Poor cardinality estimates
- Too many concurrent queries
- SQL caching large data pages
Quick Answer
Excessive memory usage causes: buffer pool pressure (too many large scans pushing data pages in), oversized memory grants (queries holding memory others need), and plan cache bloat (thousands of single-use plans from non-parameterized queries). Use sys.dm_os_memory_clerks to find which component is consuming the most.
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