Hello, I have a DB running that 20 users are accessing. I would like to force SQl server to use more memory in an effort to speed up the program accessing the DB. Does anyone know how I can make this happen?
Server 2003 x64 Enterprise
64 GB RAM
4 x AMD Opteron 8 Core procs
SQL Server 2005 Enterprise build 9.0.1399 x86
The Most ram that it will use is 3,542,512K.