MSSQL 2005 관리자 강좌_1일차

sql profiler - new - "Blocked process report" 선택

 

sess 1)

create table a (col int);
insert into a values (1);
begin tran
update a set col = 20;
commit tran

sess 2)

select * from a;

 

 

1. sp_lock;

2. sp_who2;

3. sp_readerrorlog 0;

4. windows cmd-eventvwr