Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jsmith
Starting Member
24 Posts |
 Posted - 2002-12-04 : 09:11:31
|
| Looking at the SQLServer:MemoryManager:Total Server Memory and the SQLServer:MemoryManager:Target Server Manager, the Target size is consistantly greater than the Total size.Applications other than SQL Server run on the machine. Can SQL Server be configured to 'grab' more memory, or is the only option to add more memory to the machine? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-04 : 09:14:45
|
| You can configure SQL Server with both a min and max memory setting, or set either or both to use a dynamic setting. Open Enterprise Manager, right-click the server, choose Properties, and visit the Memory tab. |
 |
|
|
|
|
|
Performance/Memory Counters