Ubuntu上SQL Server的故障排查方法

?Ubuntu??????SQL Server?,???????????????????????????:

???????????????

1. ??????? GPG ??

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

2. ?? SQL Server Ubuntu ???

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list)"

3. ?? SQL Server

sudo apt-get update
sudo apt-get install -y mssql-server

4. ?? mssql-conf setup ???????? SA ??

sudo /opt/mssql/bin/mssql-conf setup

5. ?????????

• ???? error while loading shared libraries: liblber-2.4.so.2,?? libldap-2.4-2 ?:

wget https://community-packages.deepin.com/deepin/pool/main/o/openldap/libldap-2.4-2_2.4.47+dfsg.4-1+eagle_amd64.deb
sudo dpkg -i libldap-2.4-2_2.4.47+dfsg.4-1+eagle_amd64.deb

• ???? error while loading shared libraries: libssl1.1,?? libssl1.1 ?:

wget http://security.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.1-1ubuntu2.1~18.04.23_amd64.deb
sudo dpkg -i libssl1.1_1.1.1-1ubuntu2.1~18.04.23_amd64.deb

??????

1. ??????

sudo systemctl status mssql-server --no-pager

2. ?? SQL Server ????

SQL Server ???????? /var/log/mssql/errorlog?????????????:

tail -f /var/log/mssql/errorlog

3. ?? SQL Server Profiler

SQL Server Profiler ???????????,??????? SQL Server ?????????????:

• ?? SQL Server Management Studio (SSMS) ???? SQL Server ???
• ??????? Tools -> SQL Server Profiler?
• ?? File -> New Trace,?????????????????
• ?? Run ???????

4. ??????

????????? top?vmstat?iostat ? netstat ??? CPU?????? I/O ???????????

5. ???????

??????????,?????????????????????????????????????

6. ?? SQL ??

??????????????(? SQL Server ? SET SHOWPLAN_ALL ON ? EXPLAIN)??????,??????????

??????,???????????Ubuntu??????SQL Server?????????????????,????SQL Server?????????????