You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
linux top shows me anything between 14GB and 21GB for my docker instance and only about 1 to 1.5GB of physical memory.
There is at least 4GB free which seems not to be used on the host (from a total 16GB).
There is only one DB on the server - creating a new server instance on another hardware with a backup of the database will result in less than 1GB of virtual memory.
I'm observing massive slow downs / read resource sometimes where cpu usage for that instance is over 100% :
session_id wait_type wait_time_ms
Hence why I'm investigating this instance at all. I believe the indicator of virtual memory means that massive swapping is occurring but i don't understand why, docker instance isn't even utilizing more memory just using 1-2GB max
There are not even many transactions happening during the day, it's just a test database with about 200k person records (name, address etc) and some nightly jobs going through each record.
To repeat:
Virtual Memory Usage seems to be just wrong, I'm puzzled.
Creating a new sqlserver from docker on another server and restoring the DB seems to have no issues and normal memory usage.
I don't see any errors in the error log file.
The text was updated successfully, but these errors were encountered:
linux top shows me anything between 14GB and 21GB for my docker instance and only about 1 to 1.5GB of physical memory.
There is at least 4GB free which seems not to be used on the host (from a total 16GB).
There is only one DB on the server - creating a new server instance on another hardware with a backup of the database will result in less than 1GB of virtual memory.
I'm observing massive slow downs / read resource sometimes where cpu usage for that instance is over 100% :
session_id wait_type wait_time_ms
Hence why I'm investigating this instance at all. I believe the indicator of virtual memory means that massive swapping is occurring but i don't understand why, docker instance isn't even utilizing more memory just using 1-2GB max
There are not even many transactions happening during the day, it's just a test database with about 200k person records (name, address etc) and some nightly jobs going through each record.
To repeat:
I don't see any errors in the error log file.
The text was updated successfully, but these errors were encountered: