General discussion

Locked

Memory problems/Memory leak

By awan ·
Hi, there is a problem I have at work with a server that seems to report inaccurate memory
or possibly have memory leaks, and am wondering if anyone can help me with identifying the problematic application or problem.

The server has WinNT 4.0 Server, with 4 cpus, 1 GB of ram, and the pagefile is split into 3

files with a total of 1.8 GB.

It runs a number of processes/apps such as MS Excel 97, MS Access 97, MS SQL server 7.0 with SP3, IIS/Cold Fusion 4.0, and a few misc AT/scheduled jobs.

Even though the ram usage reports approximately 750 MB of used ram (550 MB free) and 8 MB of used paging file space (1.72 GB free), I get errors such as the following when trying to open MS Access, "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." and also "Initialization of the dynamic link library C:\Winnt\system32\user32.dll failed. The process is terminating abnormally." when trying to login to the server. Task manager reports a lot of free memory, but Access still has problems running because of no memory? Are any of these programs having memory leaks? If so, which ones could be fixed by an upgrade patch/SP? I am not sure what to make of it, and any help would be greatly appreciated.

BTW, This is supposed to be a stable server and should only be scheduled reboot so I can't reboot that often.

Thanks,
Alex

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Memory problems/Memory leak

by mhoward In reply to Memory problems/Memory le ...

Actually, this is fairly common problem that I have seen in the past. As for the paging file/memory available, it will only look at the largest available block available. Since servers are not typically rebooted that often - it happens. I have also had good luck defragging the drive. This will ensure that your paging file is unfragmented. Try diskeeper - it has worked for us. Hope this helps.

-Mike

Collapse -

Memory problems/Memory leak

by awan In reply to Memory problems/Memory le ...

The question was auto-closed by TechRepublic

Collapse -

Memory problems/Memory leak

by curlergirl In reply to Memory problems/Memory le ...

I hate people who answer a question with another question, but I'm afraid I just have to do it - why are you opening MS Access on this server? Is someone actually trying to use this server as a workstation? If so, this is not a good idea, especially MS Access and especially running SQL server. The first error message can sometimes be fixed by re-running the latest service pack, so you could try that. However, my guess without further troubleshooting is that trying to open Access is causing a memory conflict or dll usage conflict with something else, and/or since the server is (properly) configured to optimize background tasks, it is not supplying enough user resources to run Access.

Collapse -

Memory problems/Memory leak

by awan In reply to Memory problems/Memory le ...

The question was auto-closed by TechRepublic

Collapse -

Memory problems/Memory leak

by Bhrdwh In reply to Memory problems/Memory le ...

Hi Alex,
do you need to run both MS Access and SQL server simultaneously sitting on the server & querying it (as a client). If no, 1. create system DSNs on other client systems & work there.
2. You page file seems ok for applications you've mentioned, I suggest you install either Disk Keeper (have to buy) or PageFileDefragmenter (freeware from site www.sysinternals.com) & use it.
3. Check your Ram with tools / diags that come with servers like Compaq or HP.
Do let me know if your problem got solved.
Akashdeep_b@yahoo.com

Collapse -

Memory problems/Memory leak

by awan In reply to Memory problems/Memory le ...

The question was auto-closed by TechRepublic

Collapse -

Memory problems/Memory leak

by awan In reply to Memory problems/Memory le ...

This question was auto closed due to inactivity

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums