Only user database on instance is ~8.5GBs.
MAX Mem set to 16GBs, which is ALL being consumed.
Virtual server has 24GBs RAM and 2 vcpus
Insert Poltergeist meme "What's happening?!"
2 vcpus have low avg utilization(<50%).
Server hosts app (using ~500MBs of RAM).
Indexes are rebuilt based on size(page count >= 1000) and avg_fragmentation(>=50%).
Thought Tempdb may be issue but not seeing wait stats to indicate.
Top 10 expensive queries aren't using much CPU, RAM(logical reads), or being executed over and over.
Wait stats show ASYNC_IO almost with 1-to-1 wait count per second, but these are coupled with high wiats for backup related waits…