MEMORYCLERK_SQLGENERAL 이 많이 쓰고 있는데요? 이넘이 뭔가요?
세상엔 똑똑한 사람이 많네........DMV 도 좋고~
결국은 메모리 leak 이 나고 있었고, 그로인해 컴파일이 계속되는 현상이 일어났음...
리부팅 후 현상이 사라졌다고 함.
패치를 하세용~ 패치~
http://support.microsoft.com/kb/2778088
SELECT cast(sum(pages_in_bytes)/1024./1024 as int) sizeMB, MO.TYPE, MC.TYPE
FROM SYS.DM_OS_MEMORY_OBJECTS MO
JOIN SYS.DM_OS_MEMORY_CLERKS MC
ON MO.PAGE_ALLOCATOR_ADDRESS=MC.PAGE_ALLOCATOR_ADDRESS
GROUP BY MO.TYPE, MC.TYPE
HAVING MC.TYPE = 'MEMORYCLERK_SQLGENERAL'
ORDER BY 1 DESC;
sizeMB TYPE TYPE
3 MEMOBJ_RESOURCE MEMORYCLERK_SQLGENERAL
3 MEMOBJ_SQLTRACE MEMORYCLERK_SQLGENERAL
0 MEMOBJ_EXCHANGEPORTS MEMORYCLERK_SQLGENERAL
0 MEMOBJ_EXCHANGEXID MEMORYCLERK_SQLGENERAL
0 MEMOBJ_METADATADB MEMORYCLERK_SQLGENERAL
0 MEMOBJ_SECURITY MEMORYCLERK_SQLGENERAL
0 MEMOBJ_SCTCLEANUP MEMORYCLERK_SQLGENERAL
0 MEMOBJ_RULETABLEGLOBAL MEMORYCLERK_SQLGENERAL
0 MEMOBJ_REPLICATION MEMORYCLERK_SQLGENERAL
0 MEMOBJ_EVENTSUBSYSTEM MEMORYCLERK_SQLGENERAL
0 MEMOBJ_GLOBALPMO MEMORYCLERK_SQLGENERAL
0 MEMOBJ_AUDIT_MGR MEMORYCLERK_SQLGENERAL
0 MEMOBJ_FULLTEXTGLOBAL MEMORYCLERK_SQLGENERAL
0 MEMOBJ_REMOTESESSIONCACHE MEMORYCLERK_SQLGENERAL
0 MEMOBJ_RESOURCESUBPROCESSDESCRIPTOR MEMORYCLERK_SQLGENERAL
0 MEMOBJ_ASYNCHSTATS MEMORYCLERK_SQLGENERAL
0 MEMOBJ_DIAGNOSTIC MEMORYCLERK_SQLGENERAL
0 MEMOBJ_SYNCPOINT MEMORYCLERK_SQLGENERAL
SELECT TOP(20) [TYPE], SUM(PAGES_KB) AS [SPA MEM, KB]
FROM SYS.DM_OS_MEMORY_CLERKS
GROUP BY [TYPE]
WITH ROLLUP
ORDER BY SUM(PAGES_KB) DESC;
SELECT cast(sum(pages_in_bytes)/1024./1024 as int) sizeMB, MO.TYPE, MC.TYPE
FROM SYS.DM_OS_MEMORY_OBJECTS MO
JOIN SYS.DM_OS_MEMORY_CLERKS MC
ON MO.PAGE_ALLOCATOR_ADDRESS=MC.PAGE_ALLOCATOR_ADDRESS
GROUP BY MO.TYPE, MC.TYPE
ORDER BY 1 DESC;
dbcc traceon (3604)
dbcc tracestatus (-1)
이름.......정말.......
http://www.sqlskills.com/blogs/paul/how-are-auto-created-column-statistics-names-generated/
누가 이 룰을 따라 복합키 통계를 수동으로 만들었다..........난..이게 버전이 좋아지면서 자동으로 만들었나..생각했다.
-_- 이름 잘 지어라....