Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    16

    Unanswered: Task Manager memory?

    I have a SQL Server 2000/E with 8 GB RAM in the machine.

    It is configured to use fixed memory size, at 7GB, and all the appropriate OS switches are set to use that.

    Everything had been working fine, but we've been having some production problems and while looking into it, I looked at task manager and while the server performance tab shows that the server is using 7+ GB, the processes tab shows sqlservr.exe at 107,724 K.

    Do you think this is a real issue, and that the server might only be using 100 mb of ram? Does anyone have any larger servers like this that they could compare?

    Thanks

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Try reading the following article; I think it contains the information that you are looking for.

    As an aside, we have a server in prod with a similar configuration to yours (8GB RAM, 7 assigned to SQL, 1 reserved to the OS). The current memory reading for SQLservr.exe is 217,632 K.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Jan 2003
    Posts
    16

    article?

    Sounds from your server readings that it's pretty similar and not a problem - but you didn't post the article link. Can you post it?

    thanks

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •