sql server on linux fundamentals for dbas · docker engine 1.8+ command what it does ......
TRANSCRIPT
Choice
Containers
Platform
Supported
version(s)
Red Hat Enterprise Linux 7.3 or 7.4
SUSE Linux Enterprise Server v12 SP2
Ubuntu 16.04
Docker Engine 1.8+
Command What it does
man Manual – help files for a command
grep Filter info from first data - sort of like POSH |
pwd Present Working Directory – shows where you
are
cd Change directory
ls List files in a directory
cat Concatenate
chmod Change directory or file read/write permissions
chown Change directory or file owner
systemctl Tool for controlling the init system – start and
stop services
File and folder permissions
rwxr-xr-x
sudo systemctl restart mssql-server
/ root (equivalent of C:\)
/bin system binaries
/dev devices
/etc host-specific system-wide config files
/home/username user's directory
/opt optional software packages - like SQL Server
/var files with frequently varying content – like data and
log files
Preview (2019) mssql-server-preview
SQL Server 2019 preview and RC
repository.
CU - base package + bug
fixes mssql-server-2017
SQL Server 2017 Cumulative Update
(CU) repository.
GDR - base package + critical
fixes/security updates mssql-server-2017-gdr
SQL Server 2017 GDR repository for
critical updates only.
sudo dpkg -i mssql-server_versionnumber_amd64.deb
sqlcmd -S localhost -U <username> -P <password>
sudo cat /var/opt/mssql/mssql.conf
sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled
true
Enable SQL Server Agent
Change default file directories
Enable Availability Groups
Set the memory limit for SQL Server
Set trace flags
...and more
df file system disk usage
dstat system statistics - sort of like
PerfMon!
free free and used memory
htop interactive process viewer
iostat CPU and I/O statistics
mpstat processor-related statistics
pidstat statistics for tasks
https://www.digitalocean.com/community/tutorials/an-introduction-
to-linux-basics
https://www.certdepot.net/rhel7-get-
started-cpu-governor/
https://www.thegeekdiary.com/understanding-automatic-numa-
balancing/
https://www.linux.com/learn/understanding-linux-file-permissions
https://docs.microsoft.com/en-us/sql/linux/sql-server-
linux-performance-best-practices?view=sql-server-2017
https://blogs.msdn.microsoft.com/bobsql/2018/12/10/sql-server-
instant-file-initialization-setfilevaliddata-windows-vs-fallocate-linux/
https://docs.microsoft.com/en-us/sql/linux/sql-
server-linux-setup?view=sql-server-2017#platforms
https://docs.microsoft.com/en-us/sql/linux/sql-server-
linux-setup?view=sql-server-2017#offline
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-
mssql-conf?view=sql-server-2017
https://github.com/Microsoft/DiagManager/tree/master/LinuxPSSDiag
https://techcommunity.microsoft.com/t5/DataCAT/How-the-SQLCAT-
Customer-Lab-is-Monitoring-SQL-on-Linux/ba-p/305467
https://github.com/Microsoft/mssql-monitoring
