USE MASTER GO IF OBJECT_ID('AP_DB_BACKUP') IS NULL EXEC ('CREATE PROC DBO.AP_DB_BACKUP AS SELECT 1 ') GO ALTER PROC [DBO].AP_DB_BACKUP @DBNAME VARCHAR(20) = 'MASTER' -- BACKUP TARGET DATABASE , @PATH VARCHAR(100) = 'C:\BACKUP\' -- OS BACKUP PATH , @BACKUP_TYPE VARCHAR(1) = 'F' -- F FULLBACKUP L LOGBACKUP D DIFFERENTIAL , @BEFORE_TARGET_TIME_HH INT = 2 -- DELETE FILE BEFORE TIME HH , @ENABLP_XP_C..

--트랜젝션 미적용USE testGOIF object_id('tblx') is not nullDROP TABLE tblxGOCREATE TABLE tblx(idx INT, c1 CHAR(100))goDBCC SQLPERF ('SYS.DM_OS_WAIT_STATS',CLEAR);DECLARE @LOOPCNT INT = 1WHILE (@LOOPCNT INSERT INTO tblx VALUES(@LOOPCNT, 'A')SET @LOOPCNT += 1ENDSELECT * FROM SYS.DM_OS_WAIT_STATSWHERE WAIT_TYPE IN ('LOGMGR_QUEUE', 'WRITELOG');--트랜젝션 적용USE testGOIF object_id('tblx') is not nullDROP TABLE t..

[테스트] 1. 테스트 환경 셋팅 -- 데이터베이스 생성 create database TESTDB use testdb go -- 임시 테이블 생성 -- drop table tab_01 create table Tab_01 ( seqNo int identity(1,1) , compareValue int default 0); go create clustered index idx_Tab_01_seqNo on Tab_01 (seqNo) go -- 20개의 compareValue 랜덤값을 가지는 데이터 입력 insert into tab_01 (compareValue) values (rand()*1000) go 20 -- 쿼리 성능 보기 위한 옵션 설정 set statistics io on set statistics..

-- 10분이상 들어오지 않은 Request 확인 SELECT st.session_id, datediff(minute, last_request_end_time, getdate()), text, last_read, last_write, getdate(), * from sys.dm_tran_session_transactions st inner join sys.dm_exec_sessions es on es.session_id = st.session_id inner join sys.dm_exec_connections ec on ec.session_id = es.session_id cross apply sys.dm_exec_sql_text(ec.most_recent_sql_handle) where datediff..

DECLARE @cTime INT DECLARE @checkTime DATETIME SET @cTime = 3 SET @checkTime = DATEADD(MINUTE, -@cTime, GETDATE()) SELECT spid, kpid, blocked, a.dbid, login_time, last_batch, open_tran, status, hostname, program_name, sql_handle, b.text FROM master.dbo.sysprocesses A cross apply SYS.DM_EXEC_SQL_TEXT(a.sql_handle) B WHERE a.open_tran > 0 and A.last_batch < @checkTime

Verify the existing MySQL installtion:From the MySQL prompt, do:You should see the current data directory:Exit the MySQL mode: exit /var/lib/mysql/ select @@datadir; mysql -u root -p Stop MySQL: sudo systemctl stop mysql Verify that MySQL is stopped: sudo systemctl status mysql Copy the data to the new location:(or whatever volume you've created to store the data) sudo rsync -av /var/lib/mysql /..