Results 1 to 8 of 8

Thread: 98 % of memory !

  1. #1
    Join Date
    Apr 2003
    Posts
    23

    98 % of memory !

    If I just test my database
    conn.open
    conn.close

    and do it 2 or three times
    windows 2000 loose all the memory (I have 400mb) sqlmangr.exe takes 98% of the memory !! and I must restart my computer

    have you had allready this problem ??

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    before doing conn.open() what statement you have in cmd , query etc?

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    You can just kill sqlmangr.exe to release memory.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    This usually happens if you pull up too much data. Did you hear your disks cranking?

  5. #5
    Join Date
    Apr 2003
    Posts
    23

    pull up too much data

    not at all my database is nearlly empty

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Did you just opened and closed connection? Did you execute anything in the database?

    If it is just open and close then I would suspect the MDAC installation in your machine. Try reinstalling it and apply the latest patch.

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    Sqlmangr.exe is a tool let you start/stop sql services, nothing to do with sql server itself. You can just close it if it causes problem.

  8. #8
    Join Date
    Apr 2003
    Posts
    23

    mDAC

    yes I just open and close without doing anythong
    it was just a connection test

    normally I have MDAC last version
    but ... I shall reinstall it

    thank you

Posting Permissions

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