[À§·Î]

<¿øÀÎ>

<SQL¹®>

CREATE TABLE #tTable (
dbid varchar (255),
objectid int,
indexid varchar (255),
buffers int,
dirty varchar (255))

insert into #tTable
EXEC ('DBCC MEMUSAGE')

select object_name(objectid), *From #tTable order by buffers desc

<Á¶Ä¡ »çÇ×>

  1. ÀÚÁÖ »ç¿ëÇÏÁö ¾Ê´Â Table¿¡ ´ëÇؼ­ À妽º Á¡°Ë
  2. »ç¿ë·®ÀÌ ¸¹Àº Table ÇöȲ ÆÄ¾Ç °¡´É
  3. ¸Þ¸ð¸®»óÀÇ µ¥ÀÌÅÍ°¡ HDD·Î ÀúÀå µÇÁö ¾ÊÀº ¾ç (Dirty)

<±âŸ>

  1. DBCC dropcleanbuffers -- »ç¿ëÁßÀÎ ¸Þ¸ð¸® ij½Ã Table »èÁ¦