Post reply

"memusage" column in sysprocesses table

  • May 16, 2007 at 8:57 am

    #73192

    Hi All - I have question about the memusage column in sysprocesses table. Does it tell the memory used by stored procs or the memory used by queries.

    I noticed the value of this column to be Zero for few spid's although they were doing insert.

    Any explanation will help.

    Regards

     

  • May 16, 2007 at 9:05 am

    #706838

    Number of pages in the procedure cache that currently are allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/60a36d36-54b3-4bd6-9cac-702205a21b16.htm

  • May 16, 2007 at 9:15 am

    #706843

    Thanks Shawn for the reply , is "procedure cache" the memory place where execution plan's for stored procedures are saved?

  • May 16, 2007 at 12:38 pm

    #706920

    Yes, the procedure cache holds compiled plans, exec plans, algebrizer trees and extended procedures.  You can use DBCC PROCCACHE to see more info about what is there.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply