NT Server - out of virtual memory

[Stan]

Hi guys...

Here is the problem.
We are building databases using SQL 7.0
The DB size varies between 800 and 1300Mb.
The machine I am using in an old Ppro 200MHz, 128Mb Ram, 2x9Gb IBM SCSI.
In less than 2 hours the PC rebooted 3 times because of a "out of virtual memory" problem, followed by a blue screen (then automatic reboot).
I increased the VM, but it did not make ny difference.

My question is: what could be the reasons why a PC could be out of virtual memory ?
- too many processes ?
- files too big to work with ?

Maybe SQL 7.0 is too hungy in memory resurces: running the same buid process using a SQL 6.5 server is OK.

Any help/advice much appreciated

Stan

[Jin Vitas]

Hello sir,

For SQL to perform properly make sure VM is set to 1.5 times the amount of physical memory.

If the virtual memory setting seems appropriate, consider the following actions:

Check that the SQL Server max server memory and min server memory configuration options are not set high enough to use most of the virtual memory. For more information, see “Server Memory Options” in Microsoft SQL Server Administrator’s Companion.

Check that other applications on the server are not using the available virtual memory.

Use the max server memory and min server memory configuration options to control the amount of memory requested by SQL Server.

Also I have noticed users that shutdown their systems, while they are still connected to the database will cause major processing problems on the NT server. Therefore make sure ur users are loggin off SQL before they shutdown windows.

[BBA]

Also bump up the registry size limit which is below the page file size setting!

BBA

[Gorx]

In the [386Enh] section, set PageOverCommit=1.
This redefines the default swap file recommendation from four times physical memory to one times physical memory.

This may help.


Try fixing the size of Virtual Memory
and defragment.
Try limiting [Vcache]

My page:
http://pages.hotbot.com/arts/gorx/windows.html