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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2009-02-19 : 12:38:51
|
| My Server is 64-bit & has 32 GB of RAM on both the nodes.One Instance is running on both the nodes .We didnot limited the RAM and we have seen lot of paging on this server .We decided to limit the Memory to 14GB inorder to leave 4GB to the OS .DO i need to restart the Server after we changed the Memory ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-02-19 : 12:52:08
|
| Yes,SQL Server account was added to that .On this Cluster box ,i have 2 servers running on each node .Why i am thinking to limit to 14 becoz ,If the other server fails to the same node .It will take 28GB and give 4GB to OS .I am planning to use this script to update the memory .Exec sp_configure 'show advanced options',1;RECONFIGURE;GOExec sp_configure 'min server memory',1024;RECONFIGURE;GOExec sp_configure 'max server memory',14336;RECONFIGURE;GOExec sp_configure 'show advanced options',0;RECONFIGURE;GO |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-02-19 : 13:11:02
|
| I was confused whether to use reconfigure with overide or just reconfigure? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 13:13:50
|
| What Edition of SQL Server do you have? |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-02-19 : 13:23:57
|
| 2005 Enterprise edition |
|
|
|
|
|
|
Memory