All Questions
3 questions
2
votes
3
answers
336
views
High Memory Usage for SqlBulkCopy
I've started to use the QueryStore to monitor my App and one of the things I noticed is the unexpected high memory usage for what I thought a simple operation:
Which would mean the statement uses ...
- 27
0
votes
0
answers
241
views
Can Query Store readonly reason 262144 be removed without clearing the Query Store?
I recently had Query Store enter readonly mode due to Readonly Reason 262144. It is documented here.
262144 - Size of in-memory items waiting to be persisted on disk has reached the internal memory ...
- 823
0
votes
1
answer
237
views
When do physical reads indicate a lack of RAM?
With Query Store, I can track how big my physical reads are and how often they occur. How can I tell if these numbers are so big that they indicate that I need more RAM?
For that it's worth, my other ...
- 823