Shipsheep on Fri, 14 Jul 2017 11:03:51
I am testing the preview with a basic (50 units) instance. Initially, I had the issue with connections not being released (same as other users described in https://social.msdn.microsoft.com/Forums/en-US/74bb38b4-9dc7-4029-977e-514917a74feb/idle-connections-are-not-released). This seems to have been fixed a few days ago, so I removed the temporary workaround I had implemented on the client side. I am now using a pool of up to 5 + 1 connections and these seem to get properly released.
I am seeing a constant increase of compute unit percentage and memory usage graph. It looks like a memory leak on the server. There should be no increased usage by my app, and definitely not one that is linear (I would expect to see spikes during times when I was running test loads, and very low usage during other times). In addition, DB requests seem to be incredibly slow in general, even though the web app and the DB are in the same region. This is an existing app that runs perfectly smooth with a dedicated 1 Core / 2 GB PostgreSQL server.
Sunil Kamath on Sat, 15 Jul 2017 16:47:39
Initially as you point out, we had a bug where we were not releasing the connection and this was fixed several weeks ago. The compute unit percentage is max (cpu percent and memory percent). When the workload is running, the pages are cached and kept in cache. Therefore when you stop the workload, the memory consumption will still show as utilized as the pages are still cached in memory. But if you observe that when no load is running on the server and the memory is still increasing, then we need to investigate this further.
As for the performance, Basic tier is not suitable if your workload is IO intensive and need lower IO latency. Standard tier is best for that purpose. Have you tried with Basic 100 compute units, as that seems to be more appropriate given you are currently running on 1 core. Basic 100 equates to 1 core.
can you send me your server name and details to firstname.lastname@example.org, if you observe memory usage increasing when no workload is running, so we can investigate ?