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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-06-07 : 07:09:55
|
| I run an SQL 2000 enviroment on a windows 2000 machine and a crm application installed on the server.. The memory on my physical memory is about 2Gb, but the system has used about 95% of the memory. therefore there is very high paging activity going on within system. now i have noticed that sql server is using a lot of memory, compared to other application on the server what can i do to redress or sort this problem please help. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-07 : 07:15:51
|
| SQL Server is designed to use as much RAM as is available, and is meant to be the only service/application running on the server. You would have to set a maximum memory using the sp_configure stored procedure (see Books Online) to prevent this. Doing so will negatively impact SQL Server performance as well. If you can separate the CRM application onto another server you'll see an improvement in both applications. As long as they reside on the same machine they will both have performance issues. |
 |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-06-07 : 07:17:53
|
You can configure SQL server to use a minimum & maximum amount of memory or a fixed amount in the server propertiesAre you sure that SQL server is using that memory, have you done any profiling etc to see whats going on?SQL server will keep hold of memory until the system needs more than is available to it then SQL server should let go of any available memory to the system.Hope that makes senseAndyBeauty is in the eyes of the beerholder  |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-06-07 : 07:20:09
|
 And as rob said seperate the app from the database serverBeauty is in the eyes of the beerholder |
|
|
|
|
|
|
Low Memory