Performance tuning in SQL Sever 2019
I have a SQL server running inside a VM A, in that same VM application is also hosted, that is used by users and they do all the data entries and basically all the CRUD operations are done.
the issue arises with the SQL server that is taking all the RAM available in VM, restarting the services released the memory and most of the time tempdb is also full, the same application is hosted on other VM B that sees larger data sets then VM A and on VM A i don't have this kind of issues. overall the DB structure (tables) is same, view and procedures are changes are per requirement of that client, manually checked that almost all the indexes are also same are application hold the logic to create index on demand (so that other clients or VM hosting the same application can have the same index)
what could be the reason for such high RAM uses, and CPU being throttled all the time on VM A and not on VM B?