The situation is the following: We have a SQL2008r2 server (64bit on 64bit Windows) with SSRS installed on it. The Max Memory is set to 6GB, the server has 12GB total memory.
The target server memory is always more than the total server memory (for instance total: 2758MB, target: 6144MB = 6GB, which is the max memory).
My problem is that the server has 6GB free memory, but the SQL Server is not using the available space, nor SSRS, or other process. Can anyone tell me is this normal? I've found nothing regarding this topic online.