Thanks for the response.

My version is windows 2000 advanced.

awe/pae enabled.

I have 4 gb of RAM.

No other application on the server other than sql.

I have added service account of sql server to page lock memory.

Every thing seems ok. But my question is about virtual memory.

I will explain my question in detail, i have 6 GB virtual physical memory enabled, 4 from C drive and 2 from another local drive. Since i enabled 4 GB of space from C drive when the system boot up does it reserve and block this 4 GB for virtual memory?

Or does it make available dynamically when it needs. if this is right what will be the error triggered to the even veiwer/sql server log when c drive run out of space?

Thanks

Thomas George