Home

출처 / 참고: Linux man-pages (tune2fs(8), xfs_info(8), statvfs(3)), Oracle Database Administrator’s Guide (Physical Database Structures), PostgreSQL Documentation (Database File Layout) 명령어: df, tune2fs, xfs_info, dumpe2fs, stat, blockdev, sqlplus 키워드: Filesystem Block Limit, Block Size, 4KB block, Datafile Auto-Extend Failure, ext4 max file si...

출처 / 참고: MySQL 8.0 Reference Manual (Server System Variables - max_connections), MariaDB Knowledge Base (Handling Too Many Connections) 명령어: mysql, mysqladmin, ss, netstat, ps, systemctl 키워드: Error 1040, Too many connections, max_connections, max_user_connections, wait_timeout, Sleep connections, Connection Pool, CONNECTION_ADMIN 사용처: 웹 서비스...

출처 / 참고: PostgreSQL Official Documentation (Viewing Locks, pg_stat_activity), MySQL Reference Manual (InnoDB Lock and Lock-Wait Information), Oracle Database Reference (V$LOCK, V$SESSION) 명령어: psql, mysql, sqlcmd, sqlplus, kill, awk 키워드: Blocking Session, Deadlock, Lock Wait, pg_blocking_pids, sys.innodb_lock_waits, v$lock, KILL SESSION, Ro...

출처 / 참고: Microsoft Learn (Troubleshoot a Full Transaction Log - SQL Server Error 9002), Microsoft Documentation (Manage the Size of the Transaction Log File) 명령어: sqlcmd, df, ls, grep, awk 키워드: Error 9002, The transaction log for database is full due to LOG_BACKUP, log_reuse_wait_desc, DBCC SQLPERF, BACKUP LOG, DBCC SHRINKFILE, FULL Recover...

출처 / 참고: Microsoft Learn (Troubleshoot TempDB contention in SQL Server), Microsoft SQL Server Internals (TempDB Allocation Architecture) 명령어: sqlcmd, top, pidstat, grep, systemctl 키워드: TempDB Contention, PAGELATCH_UP, PAGELATCH_EX, PFS, GAM, SGAM, High CPU, Trace Flag 1118, Multiple Data Files 사용처: 임시 테이블 및 테이블 변수 과다 사용 시 SQL Server CPU 점유율...

출처 / 참고: Microsoft Learn (Troubleshoot Error 18456 - Login failed for user), Microsoft Documentation (SQL Server Error Log) 명령어: sqlcmd, grep, tail, journalctl, systemctl 키워드: Error 18456, Login failed for user, State Code, SQL Server Authentication, Mixed Mode, sys.server_principals, ERRORLOG 사용처: 애플리케이션 및 DBA 클라이언트(SSMS, DBeaver)에서 MSSQL ...

출처 / 참고: Oracle Database Net Services Reference (The listener.ora File, The tnsnames.ora File), Oracle Database Net Services Administrator’s Guide (Troubleshooting Oracle Net Services) 명령어: lsnrctl, tnsping, ss, netstat, curl, iptables, firewall-cmd 키워드: ORA-12541, TNS:no listener, lsnrctl status, listener.ora, tnsnames.ora, 1521 포트, Connec...