Amicus Attorney by CARET is Slow and SQL is taking most of the memory

Amicus Attorney by CARET is slow\freezing

SQL Server will consume as much memory as you will allow it. By default, that number would encompass 100% of your numerical memory on your machine. That‘s why you're seeing what you're seeing. If you give SQL Server 24 GB of memory, then SQL Server will do its best to use 24 GB of memory. Then you have SQL Server and the OS battling for resources, and it’ll always result in poor performance. See more here

To set your SQL memory please see the Knowledge Base item below:

SQL Memory Configuration Options

For best practice please see the URL here.

Please have a qualified IT person configure your memory.