Post reply

Memory utilization on sql server

  • July 9, 2008 at 3:14 pm

    #72354

    Hi,

    If I see high memory utilization on sql server box and I have identified the particular sql server instance consuming more memory then how do I reach to a particular process in that instance which is consuming most of the memory?

    Is sysprocesses memory usage column suitable for reaching to a certain process or do I need to check something elsewhere?

    Manu

  • July 10, 2008 at 10:59 am

    #840982

    If you would like to constain how much an instance uses, you can set in the properties of instances. If you would like to look into what processes are consuming memory, you may try to use the following commands,

    sp_who2 active

    SELECT * FROM master..sysprocesses

    DBCC INPUTBUFFER(spid)

  • July 10, 2008 at 11:07 am

    #840983

    Thanks for the reply. I will use them.

    Manu

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

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