Microsoft SQL server
SQL server is slow, is it low on memory?
Get Brent Ozar Health check. https://www.brentozar.com/blitz/
Check if SQL server need to move pages out of memory with this code:
SELECT * FROM sys.dm_os_performance_counters WHERE [counter_name] = 'Page life expectancy'
“Page Life Expectancy drops can be triggered by confusing operations. By default, any one running query can get a memory grant the size of 25% of your buffer pool. Run a few of those queries at the same time, and your buffer pool gets drained – but PLE doesn’t necessarily drop. However, the instant an unrelated query runs and needs to get data that isn’t cached in RAM, your PLE will drop catastrophically. Which queries are at fault? ”
Check how memory is used by each database:
([database_id] = 32767)
(*) * 8 / 1024
)) / (1024 * 1024)