TOP memory user

• tyang

  SSCrazy

  Points: 2231

  More actions

  October 14, 2003 at 8:52 am

  #65557

  We have an application, which I think is the top memory user on the server when I query the system table sysprocesses, how could I provide the evidence to my boss? He also want to know why the app. is the top memory user.

  What is the unit for memusage in sysprocesses table? page?

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  October 14, 2003 at 1:51 pm

  #478207

  The memusage column is the number of pages in the procedure cache allocated to a process. The page size is 8kb.

  memusage * 8 = kb memory allocated for the process

• tyang

  SSCrazy

  Points: 2231

  More actions

  October 15, 2003 at 7:32 am

  #478291

  Do you know what unit is for CPU column?