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 |
|
Madhav
Starting Member
38 Posts |
 Posted - 2009-12-31 : 01:40:38
|
| Dear Experts,In our production environment,We have sqlserver 2008 (sp1) on windows server 2003 enterprise edition(64Bit) with 32GB RAM. Task manager shows sqlserver.exe taking 29,234MB memory.I monitored sqlserver buffer manager and sqlserver memory manager counters in perfmon.The following are the values.Sql server: Buffer ManagerPage life Expectancy: 1139330Buffer cache hit ration: 100.00Lazy writes: 0.00SQL server: Memory ManagerGranted workspace memory: 0 KBMaximum workspace memory: 20578 MBTarget server memory: 28311 MBTotal server memory: 28311 MBBelow is the first grid in DBCC memorystatus commandVM Reserved 40189764VM Committed 29141416Locked Pages Allocated 0Reserved Memory 1024Reserved Memory In Use 0Can any one help me is sqlserver really experiencing memory pressure??Is there any memory contention in the server? Can I have to monitor any other parameters?Why "Maximum workspace memory" parameter showing 20GB??Please help me.Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Madhav
Starting Member
38 Posts |
Posted - 2009-12-31 : 02:47:47
|
| can you explain Why "Maximum workspace memory" parameter showing 20GB??Is reducing "Maximum workspace memory" is good idea? what is the base line of these parameters when I have a physical memory of 32GB out of which 28GB was allocated to sqlserver using "max server memeory" parameter |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
Sqlserver 2008 Memory issues..