I installed Windows Server 2012 R2 on a silent PC with SSD and economy mode, 8 GB RAM.
There are installed:
- MS SQL Server 2008 R2 Express
- 2 Linux virtual machines, 1 GB RAM each
- File sharing is on
- RDP server is on
Now I encounter a 5-7 sec delay when accessing the server for the first time after idle period. This delay appears on accessing either file shares or MSSQL Server. After that it works fast.
If I access a file share at first and then connect to MSSQL Server, the very first MSSQL request works fast, and vice versa: if I access MSSQL Server at first, the very first file share access works instantly.
I could be connected to MSSQL Server for a long time, and requests are working fast, but when I disconnect and connect again, the first request works with a delay.
Could you provide a guide to troubleshooting?
How to find out whether this delay relates to hardware "economy mode" or not? Or may be to lack of RAM? Or to some other aspects?