Linux Performance Commands

for virtual memory and CPU
vmstat for IO and CPU utilization
iostat for network
netstat
參考來源：
1.https://blogs.oracle.com/openomics/system-performance-issues-check-the-io
2.https://geekflare.com/linux-performance-commands/

disk io test

磁碟測速工具 hdparm 讀取測試

#sudo hdparm -tT /dev/sda1

dd 寫入測試 (用 dd 指令寫檔到 /tmp 目錄測試)

#dd if=/dev/zero of=/tmp/bench bs=1M count=1024 && rm /tmp/bench

參考來源：https://blog.toright.com/posts/5051/linux-disk-io-%E6%95%88%E8%83%BD%E6%B8%AC%E8%A9%A6.html

MSSQL 顯示 TABLE 中的欄位名稱

MSSQL 顯示 TABLE 中的欄位名稱

USE [DB NAME]
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TABLE NAME'

exec sp_columns [TABLE NAME]

AIX 查 RAM,CPU,HD,IP

AIX UNIX RAM
# prtconf -m
# bootinfo -r
# lsattr -El sys0 -a realmem
# lsattr -El mem0

Show CPU
# prtconf -s
# pmcycles -m
# lsdev -Cc processor

# bindprocessor -q

Show Hard disks/Capacity
# lsdev -Cc disk
# lspv
# bootinfo -s hdisk0

Show IP Addresses
# ifconfig -a | grep inet
# lsattr -El en0 -a netaddr

paging space
lsps -a

參考來源：http://www.unixmantra.com/2013/09/aix-listing-cpu-memory-ram-harddisks-ip-address.html