¡¡¡¡4.·Ç»º³å³ØÄÚ´æ·Ö²¼
¡¡¡¡SELECT M.type,
¡¡¡¡SUM(M.virtual_memory_reserved_kb) AS VirtualMemoryReservedKB,
¡¡¡¡SUM(M.virtual_memory_committed_kb) AS VirtualMemortCommitedKB,
¡¡¡¡SUM(M.shared_memory_committed_kb) AS SharedMemroyCommittedKB,
¡¡¡¡SUM(M.shared_memory_reserved_kb) AS SharedMemroyReservedKB,
¡¡¡¡SUM(M.multi_pages_kb) AS MultiPagesKB,
¡¡¡¡SUM(M.single_pages_kb) AS SinglePagesKB,
¡¡¡¡SUM(M.multi_pages_kb)+SUM(M.single_pages_kb) AS TotalPagesKB
¡¡¡¡FROM sys.dm_os_memory_clerks M
¡¡¡¡GROUP BY M.type
¡¡¡¡ORDER BY TotalPagesKB DESC
¡¡¡¡ÒѾ°´ÕÕÄÚ´æʹÓÃÅÅÐò£¬ÕÒµ½Ê¹ÓÃÄÚ´æ×î¶àµÄ²¿·Ö¡£·ÖÎöʹÓõÄÔÒò£¬²¢½â¾ö¡£
¡¡¡¡°¸Àý
¡¡¡¡Ä³¿Í»§µÄ¿Í»§ÏµÍ³Ê¹ÓûºÂý£¬Í¨¹ýÉÏÃæµÄÅųý·½·¨ÒÀ´ÎÅŲ飬×îºóÕÒµ½ÊÇ·Ç»º³å³Ø²¿·ÖµÄ MEMORYCLERK_SQLOPTIMIZERÕ¼ÓÃÄÚ´æÌ«¶àÔì³É
¡¡¡¡½â¾ö
sp_configure N'show advanced options',1 GO reconfigure GO sp_configure N'optimize for ad hoc workloads',1 GO sp_configure N'show advanced options',1 GO reconfigure GO |
¡¡¡¡¿ªÆôÉÏÃæµÄÑ¡Ïîºó£¬ÄÚ´æÈÔȻûÓÐ×Ô¶¯ÊÍ·Å¡£ÖØÆôSQL SERVER ·þÎñ£¬ÊͷŵôÒѾʹÓõôµÄÄÚ´æ¡£