Kelly,

Are you using IDE hard drives in this server?

Generally, when a RAM shortage is the problem, CPU usage will remain low if you have a SCSI controller. With a SCSI controller, high CPU usage on SQL Server is a good indication that RAM is not the bottleneck.

Also, it is not uncommon for SQL Server to keep the RAM allocated for optimizing queries.

Are the queries running slower than you expect?

>I am having an issue with the current machine that SQL server is running on. What's happening is the RAM of the server is not being released when a request is finished. The machine is a DELL twin 1.3 Ghz with 1 Gb of RAM. We are using VFP 8 passthrough to access the data on the machine. Every call to the server is calling a Stored procedure to return a set of data. What I need to find out is what is causing the RAM to stay locked. Right now after the first call to the server everyone else is using the paging file and the CPU activity is off the chart. Where can I start looking to figure out what is going on?
>
>Thanks in advance
>Kelly