Anyway, the warning message occurs because when you have AWE enabled. Set Working Set Size option is not supported when Address Windowing Extensions (AWE) option is enabled on your SQL Server 2000. In your case AWE is not in picture.
The most possible causes for this is system is either low on memory or tempdb is near to its capacity.
Take help of PERFMON to know the stats of h/w resources on SQL Server. SQL makes use of working sets in both. Check the file size on tempdb and check disk capacity where those located, check memory claimed by sql server and total system memory using task manager.
BTW what is the level of Service pack on SQL & OS?
So... Sorry.... It's not SP4 for SQL !!! Sorry again.
It's SQL Service Pack 3a.
So. I just configure the server in Non-dynamic allocation memory.
The memory used bu SQL is 512 Mb
I put the memory reserved for SQL to 512 Mb.
My total memory on the server is 1Gb...
What do you think about this ?
Normally, I think, AWE is not implemented on this server. But befor I put the memory in static, i was in dynamic between 0Mb to 512Mb. I rebooted the server and I have the same mesage again !!! I don't understand.
Sorry for my english but I'm french and, please, use a simple english !