Post reply

Memory Issues in SQL2k reporting incorrectly

  • June 28, 2006 at 11:19 am

    #366615

    Anyone aware of mssql2k reporting memory incorrectly in task manager?  Is there a hotfix or patch for this?  Already have some scripts to show memory being used but just thought this "fix" would help or is it something you just ignore and use scripts?

    Please help with ideas....

    Thanks

    DHeath

     

     

    DHeath

  • June 29, 2006 at 5:58 am

    #646637

    Hi, it is not necessarily incorrect. SQL server will hold on to allocated memory if there are no other processes requesting memory, and will do so untill another process wants some.

    This is what is reported in task manager (allocated mem), and would not necessarily be the same as the currently used memory reported by your script.

    Hope this helps,

    Martin.

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

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