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@hotmail.com
Starting Member
6 Posts |
 Posted - 2009-01-28 : 17:23:56
|
| Hello! We have installed SQL Server 2005 64-bit Standard Edition on two node cluster (Windows 2003 EE) with 32GB or RAM. I have limited SQL Server memory usage to 26GB. I am looking at perfmon Target Server Memory (KB) - 27262976 and Total Server Memory (KB) - 3228128 counters under SQLServer: Memory Manager. I am puzzled as to why SQL Server is unable to consume all memory it is 'willing to consume'. Since this is 64-bit Standard Edition, I can't configure 'lock pages in memory' privilege. Any help is greatly appreciated.Thanks,Igor |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 17:28:32
|
| SQL Server is infact consuming all Server Memory. Do you see any performance issues with STD Edition? |
 |
|
|
imarchenko@hotmail.com
Starting Member
6 Posts |
Posted - 2009-01-29 : 19:47:27
|
| I executed DBCC CHECKDB and Target Memory went up. SQL Server has consumed more memory when there was a need.Thanks,Igor |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-29 : 19:49:25
|
quote:
Originally posted by imarchenko@hotmail.com
I executed DBCC CHECKDB and Target Memory went up. SQL Server has consumed more memory when there was a need.Thanks,Igor
That is how SQL Server is. |
|
|
|
|
|
|
Total Memory vs. Target Memory