Worktables FROM Cache Ratio

Copper Contributor

Hello. For some reason, one of my MS SQL 2019 runs shows that the "Worktable Ratio from Cache" is around "62%". I checked that no parameters were changed. My programmer says they don't change anything. Since I have no experience as a DBA, I would welcome any hint of what I might be research next.

In sys.dm_os_performance_counters i see 

Worktables From Cache Ratio 4964
Worktables From Cache Base 8002

I assumed there was not enough memory, but Buffer cache hit ratio is around 100%

Buffer cache hit ratio 14529
Buffer cache hit ratio base 14529

2 Replies
And what exactly is the problem here? Do you have any performance or other issues?


No. There are no problems with performance, it just suddenly dropped from 92% to 62% after a reboot and does not rise. On other servers, this value also drops when rebooting, but gradually returns to normal. I'm afraid this is some kind of symptom.