블로그 이미지
010-9967-0955 보미아빠

카테고리

보미아빠, 석이 (500)
밥벌이 (16)
싸이클 (1)
일상 (1)
Total
Today
Yesterday

달력

« » 2013.12
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31

공지사항

최근에 올라온 글

'2013/12'에 해당되는 글 4건

  1. 2013.12.30 잠금 리소스 해석
  2. 2013.12.10 gen script
  3. 2013.12.08 xevent meta query
  4. 2013.12.08 lock escalation
http://www.sqlnotes.info/2011/10/24/locking-and-blocking-5-lock-resources-in-extended-events/

right('0X00EE00',2) 1자 초과로 읽을떄 처음 읽는 값이 null이믄 제외하고 읽더라고

 

SELECT *,%%lockres%%,SYS.FN_PHYSLOCFORMATTER(%%PHYSLOC%%) [FILEID:PAGEID:SLOTID],SYS.FN_GETROWSETIDFROMROWDUMP(%%ROWDUMP%%),%%rowdump%% partionid FROM DBO.TEST;

 

by 안인옥~

Posted by 보미아빠
, |

gen script

카테고리 없음 / 2013. 12. 10. 16:04

http://www.snazzo.com/downloads/generate_inserts_2005.txt
원본
[] 제거

script.txt

 

Posted by 보미아빠
, |

xevent meta query

카테고리 없음 / 2013. 12. 8. 02:50

SELECT * FROM SYSOBJECTS WHERE NAME LIKE 'DM_XE_%' AND NAME NOT LIKE 'DM_XE_SESSION%'
GO

 

 

DECLARE @KEYWORD VARCHAR(100) = 'lock_escalation'
SELECT 'DM_XE_PACKAGES', * FROM SYS.DM_XE_PACKAGES WHERE NAME LIKE '%'+@KEYWORD+'%' OR DESCRIPTION LIKE '%'+@KEYWORD+'%'
SELECT 'DM_XE_OBJECTS',* FROM SYS.DM_XE_OBJECTS WHERE NAME LIKE '%'+@KEYWORD+'%' OR DESCRIPTION LIKE '%'+@KEYWORD+'%'
SELECT 'DM_XE_OBJECT_COLUMNS',* FROM SYS.DM_XE_OBJECT_COLUMNS WHERE NAME LIKE '%'+@KEYWORD+'%' OR DESCRIPTION LIKE '%'+@KEYWORD+'%'
SELECT 'DM_XE_MAP_VALUES',* FROM SYS.DM_XE_MAP_VALUES WHERE NAME LIKE '%'+@KEYWORD+'%' OR MAP_VALUE LIKE '%'+@KEYWORD+'%'
GO

 

 

SELECT P.NAME PACKAGE_NAME, O.NAME OBJECT_NAME, OBJECT_TYPE
  , OC.NAME OBJECT_COLUMNS_NAME, CASE COLUMN_TYPE WHEN 'DATA' THEN '=' WHEN 'CUSTOMIZABLE' THEN '=(1)' ELSE '' END PREDICATE_SRC
  , OC.TYPE_NAME OBJECT_COLUMN_TYPE_NAME, OC.COLUMN_TYPE OBJECT_COLUMN_TYPE
  , MV.MAP_KEY MAP_VALUES_KEY, MV.MAP_VALUE MAP_VALUES_MAP_VALUE
  FROM SYS.DM_XE_PACKAGES P
  LEFT JOIN SYS.DM_XE_OBJECTS O
    ON P.GUID = O.PACKAGE_GUID
  LEFT JOIN SYS.DM_XE_OBJECT_COLUMNS OC
    ON O.NAME = OC.OBJECT_NAME
   AND O.PACKAGE_GUID = OC.OBJECT_PACKAGE_GUID
  LEFT JOIN SYS.DM_XE_MAP_VALUES MV
    ON (OC.OBJECT_PACKAGE_GUID = MV.OBJECT_PACKAGE_GUID AND OC.TYPE_NAME = MV.NAME)
    OR (O.NAME = MV.NAME AND O.OBJECT_TYPE ='MAP')
 WHERE
 --  P.NAME = 'SQLOS'
   --AND P.DESCRIPTION =''
   --AND
   O.NAME ='LOCK_ESCALATION'
   --AND O.DESCRIPTION = ''
   --AND OC.NAME = 'MAX_MEMORY_GRANT'
   --AND OC.DESCRIPTION = ''
   --AND MV.NAME = 'lock_escalation_cause'
   --AND MV.MAP_VALUE = ''
 ORDER BY
    P.NAME
  , O.NAME
  , CASE OC.COLUMN_TYPE WHEN 'READONLY' THEN 1 WHEN 'CUSTOMIZABLE' THEN 2 WHEN 'DATA' THEN 3 ELSE NULL END 
  , OC.COLUMN_ID
  , MV.NAME
  , MV.MAP_KEY

Posted by 보미아빠
, |

lock escalation

카테고리 없음 / 2013. 12. 8. 01:07


http://support.microsoft.com/kb/2801413/en-us
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx
http://beyondrelational.com/modules/24/syndicated/501/posts/12764/interrogating-lock-escalation-thresholds-part-1.aspx

 

 

querytraceon 으로 1211 같은건 안 먹는다.

Posted by 보미아빠
, |

최근에 달린 댓글

최근에 받은 트랙백

글 보관함