Post reply

Identify the memory usage for individual database

  • September 16, 2003 at 2:53 pm

    #65723

    The SQL memory usage is high, how to identify which database is hiting the memory?

    Which counter should be focused on if check it from table 'sysperfinfo'?

  • September 18, 2003 at 10:19 am

    #474905

    Instead of searching the db, you should check what process in consuming the sql resources, and then if necesary find out from what db that process is connected.

    You can run sp_who2 and dbcc inputbuffer to know wich process is that.

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

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