MS SQL: Resolve deadlocks - Snapshot Isolation

ALTER DATABASE MVIC_Banksy
SET READ_COMMITTED_SNAPSHOT ON;
GO

ALTER DATABASE MVIC_Banksy
SET ALLOW_SNAPSHOT_ISOLATION ON;
GO

Linux base command

nohup vmstat 10 2 >1.txt - log perf statistics

vi 1.txt - view file
i - edit file
wq - save and quite

rm -f -r 9.txt - delete file
rm "old_name" new_name - rename

chmod +x stats.sh - allow to perform
./stats.sh - perform

( nohup ./jmeter -n -t S7_-_Apache_vs._lighttpd.jmx -l log.csv & ) - start Jmeter test

ls -la - browse dir
.. - up

tar xzf 1.tar.gz - unpack

tar cvjf file.tar.bz2 filedir1 filedir2 filedir2... - pack files

kill -9 [pid] - kill a process

ps -ef |grep java - the last executed java process

df -h - recourse utilization

ulimit -n - opened files amount

sudo /etc/init.d/apache2 - stop Apache
sudo /etc/init.d/lighttpd - start lighty

which - search

netstat -ant | grep 172.21.10.80 | wc -l - ip connects amount

sudo atop - processors utilization

Saturation Point

Saturation point: certain amount of concurrent users adjoining with maximum CPU utilization and peak throughput;
Adding any more concurrent users will lead to degradation of response time and throughput, and will cause peak CPU utilization.