We have a Windows NT 4.0 sp3 workstation with MS SQL Workstation 6.5. As
soon as the machine boots up, I check MEM USAGE and VM for SQLSERVR.exe.
The MEM USAGE immediately starts out at 15 MB and the VM at 25 MB's. This
seems high to begin with. The main problem is that the MEM and VM
continually increase. If we leave it running we end up with around 57 MB's
of MEM and 226 MB ov VM before we get our first "Your system has run out of
Virtual Memory, please shut down...." error message.
We uninstalled SQL Workstation, rebooted, reinstalled, rebooted and checked
the MEM and VM again. We had the same result. (Note we have MSDTC and SQL
EXEC on Manual Start, so they were not running).
Any ideas, thanks:
Mike Hanby MCP