I have one terminal on my network that is using a crazy amount of ram. It is slowing the computer way down. How can I adjust the amount of ram that sqlserver can use? In task manager it is always at the top of the list of memory hogs.
How do I fix this?
I thought it might be a virus but an investigation turned up nothing suspicious.
Scott