On the db server, we have 4 GB of memory. Currently, the memory utilization of Sql Server 2005 on that server is 1,725,000 K and the total memory usage is stable at 2.04 GB. The Cpu usage on the server though is at 99% almost constantly.
How can I increase the memory that Sql Server uses so that it performs more operations using memory rather than reading from disk etc.?