메칸더 2013.04.15 20:25 Views : 6069
PAGEIOLATCH WAIT_TYPE을 강제로 발생시켜보고 싶은데...
어떻게 해야할까요 ㅠ
2013.04.16 15:32
IF OBJECT_ID ('TBLX') IS NOT NULLDROP TABLE TBLX
GO
CREATE TABLE TBLX (C1 INT,C2 CHAR(5000))GO
INSERT TBLX SELECT TOP 100000 ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) , 'A' FROM SYSOBJECTS A1 , SYSOBJECTS A2 , SYSOBJECTS A3 , SYSOBJECTS A4 , SYSOBJECTS A5GO
CHECKPOINT DBCC DROPCLEANBUFFERS GO
UPDATE STATISTICS TBLX WITH ROWCOUNT = 1, PAGECOUNT = 1GO
SELECT MAX(C2) FROM TBLX GO
-- 다른 SESSION SELECT * FROM MASTER.DBO.SYSPROCESSES WHERE spid > 50 and kpid <> 0
cmd_comment_vote_user Upvote0 Downvote0
2013.04.17 14:29
감사합니다 정말 많은 도움이 되었습니다.
Keep me signed in.
IF OBJECT_ID ('TBLX') IS NOT NULL
DROP TABLE TBLX
GO
CREATE TABLE TBLX
(C1 INT
,C2 CHAR(5000)
)
GO
INSERT TBLX
SELECT TOP 100000
ROW_NUMBER() OVER(ORDER BY (SELECT NULL))
, 'A'
FROM SYSOBJECTS A1
, SYSOBJECTS A2
, SYSOBJECTS A3
, SYSOBJECTS A4
, SYSOBJECTS A5
GO
CHECKPOINT
DBCC DROPCLEANBUFFERS
GO
UPDATE STATISTICS TBLX WITH ROWCOUNT = 1, PAGECOUNT = 1
GO
SELECT MAX(C2) FROM TBLX
GO
-- 다른 SESSION
SELECT * FROM MASTER.DBO.SYSPROCESSES WHERE spid > 50 and kpid <> 0