Somebody knows of what this error message from ms sql 7.0 kernel is and how
to correct it ?
I am urgently request for a solution for this case from my SQL Server:
From EventLog: 17122 : initdata: Warning: Could not set working set size
to 1038848 KB.
SQL Server configuration:
SQL Server 7.0 + SP3 on NT 4.0 + SP5
SQL: Dymanic memory configuration: max = 900 M
1.0 G Memory
I have a VB program on this SQL server processing large volumn of data
The SQL WriteLog process increasingly takes memory and the SQL Server
is also increased.
(1) I have already setup a Backup Log agent to truncate the log hourly
with Trunc Log on CheckPoint = False
(2) I have also test not to use the hourly log backup with Trunc Log on
CheckPoint = True
(3) I have also setup a non-logged UpdateText statement in my program
(e.g. if i mod 1000 = 0 then execute this update text statement)
in a bid to invalidate the log backup sequence.
But all in vain.
Value of i 1 -->
1000 --> 10000 --> 60000
Transaction Log Size 10 M 15 M
56 M 175 M
SQL Server DB Size 50 M 60 M
170 M 450 M
WriteLog Sys Process Memory 5 M 50 M
500 M 900 M
SQL Memory Used (dynamically) 256 M 312 M
845 M 940 M
The log size, db size, and the memory used is the roughly figure.
You can see the WriteLog sys process memory takes so much memory during
however the transaction log size does not take so much.
The SQL Server takes memory increasingly, the VB finally only have a
little to run,
and performance is dropped dramatically.
Any ideas, hints or suggestions are highly appreciated.