[mssql] cache, session 확인 및 제거

[ MS SQL Cache 확인 및 날리기 ]

select * from syscacheobjects where [sql] like '%GetPartnerAccountOrderDetailCodeToOrderCode(orderDetailCode) strOrderCodeAccount %'

select * from syscacheobjects

dbcc freeproccache

dbcc flushprocindb(7)

[ MS SQL Session 확인 및 날리기 ]

MSSQL 현재 데이터베이스에 접속중인 세션정보 / 아이피 확인방법

SELECT P.spid, P.login_time, P.last_batch, P.status, P.program_name, P.cmd, C.client_net_address

FROM sys.sysprocesses AS P INNER JOIN sys.dm_exec_connections AS C

ON P.spid = C.session_id

참고 : http://mani4u.tistory.com/41