SQL 6.5 - Server virtual memory leak - any ideas?

[Andrei Salnikov]

Local SQL 6.5 SP4 on a Windows NT SP4 workstation (Pentium 350 / 128 MB).
SQL server has 32 MB of RAM. It starts well but begins continuously eating up virtual memory by 16k blocks in a second,
until it takes all virtual memory.

Server's shutdown generate following error in Event log System section:

Event ID: 7011
Source: Service Control Manager
Description: Timeout (120000 milliseconds) waiting for transaction response

When I start Server from command prompt with -f switch, it did not eat virtual memory,
and did not generate any error in Event log at shutdown.

Many thanks for any help.

mailto:andrejss@bank.lv

On 11/20/98 11:23:42 AM, Andrei Salnikov wrote:
> Local SQL 6.5 SP4 on a Windows NT SP4 workstation (Pentium 350 / 128
> MB).
SQL server has 32 MB of RAM. It starts well but begins continuously
> eating up virtual memory by 16k blocks in a second,
until it takes all
> virtual memory.

Server's shutdown generate following error in Event
> log System section:

Event ID: 7011
Source: Service Control
> Manager
Description: Timeout (120000 milliseconds) waiting for transaction
> response

When I start Server from command prompt with -f switch, it did
> not eat virtual memory,
and did not generate any error in Event log at
> shutdown.

Many thanks for any help.

mailto:andrejss@bank.lv

Check the configuration, maybe you allocate too many memory to SQL.

>Check the configuration, maybe you allocate too many memory to SQL.


No SQL has only 32Mb from 128Mb
Here is sp_configure output:

NORMAL STARTUP OUTPUT:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask 0 2147483647 0 0
allow updates 0 1 0 0
backup buffer size 1 32 1 1
backup threads 0 32 5 5
cursor threshold -1 2147483647 -1 -1
database size 2 10000 2 2
default language 0 9999 0 0
default sortorder id 0 255 154 154
fill factor 0 100 0 0
free buffers 20 524288 819 819
hash buckets 4999 265003 7993 7993
language in cache 3 100 3 3
LE threshold maximum 2 500000 200 200
LE threshold minimum 2 500000 20 20
LE threshold percent 1 100 0 0
locks 5000 2147483647 5000 5000
LogLRU buffers 0 2147483647 0 0
logwrite sleep (ms) -1 500 0 0
max async IO 1 1024 8 8
max lazywrite IO 1 1024 8 8
max text repl size 0 2147483647 65536 65536
max worker threads 10 1024 255 255
media retention 0 365 0 0
memory 2800 1048576 16384 16384
nested triggers 0 1 1 1
network packet size 512 32767 4096 4096
open databases 5 32767 20 20
open objects 100 2147483647 500 500
priority boost 0 1 0 0
procedure cache 1 99 30 30
Protection cache size 1 8192 15 15
RA cache hit limit 1 255 4 4
RA cache miss limit 1 255 3 3
RA delay 0 500 15 15
RA pre-fetches 1 1000 3 3
RA slots per thread 1 255 5 5
RA worker threads 0 255 3 3
recovery flags 0 1 0 0
recovery interval 1 32767 5 5
remote access 0 1 1 1
remote conn timeout -1 32767 10 10
remote login timeout 0 2147483647 5 5
remote proc trans 0 1 0 0
remote query timeout 0 2147483647 0 0
remote sites 0 256 10 10
resource timeout 5 2147483647 10 10
set working set size 0 1 0 0
show advanced options 0 1 1 1
SMP concurrency -1 64 0 1
sort pages 64 511 64 64
spin counter 1 2147483647 10000 0
tempdb in ram (MB) 0 2044 0 0
time slice 50 1000 100 100
user connections 5 32767 15 15
user options 0 4095 0 0


STARTUP with -f switch OUTPUT:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask 0 2147483647 0 0
allow updates 0 1 0 1
backup buffer size 1 32 1 1
backup threads 0 32 5 5
cursor threshold -1 2147483647 -1 -1
database size 2 10000 2 2
default language 0 9999 0 0
default sortorder id 0 255 154 154
fill factor 0 100 0 0
free buffers 20 524288 819 20
hash buckets 4999 265003 7993 7993
language in cache 3 100 3 3
LE threshold maximum 2 500000 200 200
LE threshold minimum 2 500000 20 20
LE threshold percent 1 100 0 0
locks 5000 2147483647 5000 5000
LogLRU buffers 0 2147483647 0 0
logwrite sleep (ms) -1 500 0 0
max async IO 1 1024 8 2
max lazywrite IO 1 1024 8 2
max text repl size 0 2147483647 65536 65536
max worker threads 10 1024 255 255
media retention 0 365 0 0
memory 2800 1048576 16384 1809
nested triggers 0 1 1 1
network packet size 512 32767 4096 512
open databases 5 32767 20 5
open objects 100 2147483647 500 100
priority boost 0 1 0 0
procedure cache 1 99 30 50
Protection cache size 1 8192 15 15
RA cache hit limit 1 255 4 4
RA cache miss limit 1 255 3 3
RA delay 0 500 15 15
RA pre-fetches 1 1000 3 3
RA slots per thread 1 255 5 5
RA worker threads 0 255 3 0
recovery flags 0 1 0 0
recovery interval 1 32767 5 5
remote access 0 1 1 0
remote conn timeout -1 32767 10 10
remote login timeout 0 2147483647 5 5
remote proc trans 0 1 0 0
remote query timeout 0 2147483647 0 0
remote sites 0 256 10 0
resource timeout 5 2147483647 10 10
set working set size 0 1 0 0
show advanced options 0 1 1 1
SMP concurrency -1 64 0 1
sort pages 64 511 64 64
spin counter 1 2147483647 10000 0
tempdb in ram (MB) 0 2044 0 2
time slice 50 1000 100 100
user connections 5 32767 15 5
user options 0 4095 0 0