I am running the microsoft/mssql-server-windows-developer container on Windows 10.
Here is my docker version:
Client:
Version: 17.09.0-ce
API version: 1.32
Go version: go1.8.3
Git commit: afdb6d4
Built: Tue Sep 26 22:40:09 2017
OS/Arch: windows/amd64Server:
Version: 17.09.0-ce
API version: 1.32 (minimum version 1.24)
Go version: go1.8.3
Git commit: afdb6d4
Built: Tue Sep 26 22:50:27 2017
OS/Arch: windows/amd64
Experimental: true
I bring up my container using docker compose:
version: ‘2.2’
services:
db1:
image: microsoft/mssql-server-windows-developer
volumes:
- db-data:C:\sqldata
environment:
sa_password: “mypass”
ACCEPT_EULA: “Y”
hostname: ms_sql
volumes:
db-data:
I have a web app running in another container. When it contacts the sql server, the performance is acceptable.
However, when I connect from my host using SSMS, the performance is very slow. Simple operations like connecting, viewing the list of databases, viewing the list of tables, opening a query window, etc. each take 15-30 seconds.
I have tried modifying my compose file to increase resources available to sql server:
mem_limit: 4g
cpu_percent: 50
cpu_count: 2
But this did not make a noticeable difference. The Vmmem process consumes the full amount of memory available, all the time. The CPU hovers around 1% and does not appear to increase during a slow operation.
Ideas on why this is running so slowly?