|
Posted by paullie69 on 02/06/07 10:53
Hi all
Inherited environment :
Windows 2003 SP1 Ent
SQL 2000 Standard
16 GB RAM
BOOT INI Switches : /3GB /PAE
I understand that SQL 2000 standard can only address > 2 GB and
therefore the /3GB switch will only rob the OS of a GB of RAM without
giving it to SQL as it can only use > 2GB
We have an active X job invoked from a SQL job ran overnight which
copies large CSVs (> 5GB) from one folder to another on the SQL
server. This runs ok for a while (normally after a reboot) but
intermittently comes back with "Not enough server storage is available
to process this command"
The files can then be copied over manually without problem and the
rest of the job ran successfully
Could this error be related to only having 1 GB available to the OS as
its a file copy ?
Would it be best to remove both the /3GB AND /PAE switches or just
the /3GB switch to give the OS at least 2 GB to play with ?
Thankyou in advance for your replies
Cheers
Paul
Navigation:
[Reply to this message]
|