Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Memory usage in Task Manager


    I am a newbie on SQL server and my problem is this:

    My SQL server runs with many client queries and after a while I can observe that the meory usage of the SQL server shown in the Windows Task Manager is growing up (e.g. 260 MB !!!).

    I checked the online books and found the settings "min/max server memory" which I set to

    min = 4 MB
    max = 20 MB

    by Enterprise manager.

    Then I restarted my SQL server, checked the memory settings again by Enterprise manager and started many client queries. The memory usage in Task Manager nevertheless exeeded the 20 MB.

    What is my failure? How can I limit the memory usage of SQL server?

    Thank you very much for any help...

  2. #2
    Join Date
    Sep 2003
    Dallas, Texas

    Re: Memory usage in Task Manager

    After the change, did you stop and restart SQL?

Posting Permissions

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