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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-01-22 : 02:25:38
|
| Hii Have used window2003 sp2 as cluster.in cpu1 install a erp application and other cpu2 install sql server2005.both cpu use same memory.the erp application which are not use high resource of memory.so it is posible to use cpu1 memory use in cpu2. any can be done this process and how is the workthanks in advance |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-22 : 03:35:17
|
| I'm sorry but you question is unclear. But as far as I know there is no way to assign certain amounts of memory to processes running on specific cpu's. What you can do though is to set a maximum value for the RAM sql server uses (it will take all that's available if you don't specify anything). Right-click your server in management studio, go to Memory and set a sensible amount in the "Max server memory(in MB)"-field...- Lumbagohttp://xkcd.com/327/ |
 |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-01-22 : 03:58:44
|
| thanks to replayi have use cpu1 and cpu2 are both 8-8 GB Memory. i have set the 6 GB Memory of sql serevr. it can posible to use the cpu1 memory in cpu2 or sql server |
|
|
|
|
|
|
Memory Use in Cluster