New answers tagged

2 votes
Accepted

76% of the RAM usage on my server is TEXT_MIX_PAGE in tempdb. What does this indicate?

The idea of the command is that it shows what percentage of your server's RAM is being used by what type of pages in each of your databases. It'll show you what type of pages are in the buffer pool ...
Sean Gallardy's user avatar
4 votes
Accepted

Can Query Store Show Spills To Tempdb?

nope But you may be able to infer that a select spilled to disk if values for average or total writes are "high", and the query plan: Doesn't contain any spooling operators Does contain ...
Erik Darling's user avatar
  • 40.6k

Top 50 recent answers are included