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 |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2008-12-04 : 00:07:34
|
| Hello! We have just configured SQL Server 2005 64-bit two node active/passive cluster with 32 GB of RAM. I have limited SQL Server memory usage to 26 GB. Total Server Memory (KB) shows value 16MB at the moment. Target Server Memory (KB) is showing 27262976 (26 GB). I am wondering if such low value of Total Server Memory is expected since SQL Server just started and there is not much going on. I would expect this value to increase over time. Any comments are greatly appreciated.Thanks,Igor |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-04 : 09:43:41
|
| Correct!!. You should enable 'lock pages in Memory' if Enterprise Edition. |
 |
|
|
Gerrard
Starting Member
4 Posts |
Posted - 2008-12-08 : 10:19:56
|
| - -! Recently, I want to change the SQL version to 64bit enterprise(MSSQL2005)...but it worry about that .. Theoretically speaking, The 64-bit version of SQL2005 not need to enable AWE and "lock pages in Memory" But I do some testing in a Microcomputer(NO PC server) wind2003 64bit + sql2005 64bit... CPU2.4HZ + memory 3.24G(I'am not set the Awe and lock pages in memory...just the Windows default)And the toal server memory(KB) shows values 2.6G and Target Server Memory (KB) is showing or so 2.6G....And few minutes later ,two values anomaly change....= =(1G~~3G)..but I can not good for monitor the SQl2005 memory ...(may be something is far beyond me)..Enjoy lonely |
|
|
|
|
|
|
SQL Server 2005 64-bit Total Server Memory(KB)