I have Microsoft SQL Server Standard Edition (64-bit) running on Windows Server 2008 R2 Standard (64-bit) with 32GB RAM. It's only database server that runs on this machine. Generally it works fine but I sometimes I get 'could not open a connection to SQL Server' so I am trying to eliminate potential causes one by one. I started with server memory:
In my database server properties Maximum server memory (in MB) is set to 2147483647 which I suppose means that SQL server dynamically takes how much memory it needs,
though sqlserver.exe process consumes only about 7 700 000 KB. Does database need only that amount or maybe there is some limit set elsewhere?