The issue is related to SQL SERVER Performance issue for sure

Increasing memory is one of the best ways to improve SQL Server performance

because more data can be cached in memory.

You can check you memory usage by using storage management for SQL related tools also