• antoninSQL - Wednesday, February 28, 2018 10:58 PM

    Memory see on task manager :
    --Sqlserver.exe  : 135 MB now  (2756 before restart)
    --Reporting services MB : 73 MB  (977 before restart)

    Why SQL server.exe and reporting services use now less than before restart.

    Regardless of how accurate those figures are, SQL Server will only grab the memory it needs to start.  It'll take more and more as and when it needs it (for example to cache data or plans) until it reaches either the max server memory or the available memory on the computer.  It'll give back memory when requested by the operating system, subject to the value of min server memory.  That's a basic overview - there may be circumstances under which it will grab more memory than expected, especially in older versions.  I'm not sure whether or not Reporting Services behaves in the same way.

    John