Microsoft SQL Fixes

Troubleshooting mssql linux container

login interactively
docker run --rm -h cxdb --name cxdb -e 'ACCEPT_EULA=Y' -e SA_PASSWORD=$sa_password -e 'MSSQL_PID=Express' -p 1433:1433 -v db:/var/opt/mssql -it microsoft/mssql-server-linux bash

then run
/opt/mssql/bin/sqlservr

some more hints
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker

What events to trace when trying to catch a lock timeout with the SQL Server Profiler

Make sure to enable

• Lock:Timeout (timeout > 0)
• Exception
• SP:StmtStarting
• RPC:Starting

@Troubleshooting @Microsoft