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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-06-15 : 23:53:20
|
| Dear All,I recently took the Full time Production DBA job and will actively involving in production DB maintanace.I need help in getting exactly amount of RAM memory SQL server is using.Also if we have 32GB of RAM how do we enable to maximum utilization of RAM with SQL server for better optimal performance.It would be great if experianced person who already did this operation in production environment.Thanks,Gangadhar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-06-16 : 02:15:57
|
| We are using 32-Bit and we are using Windows server 2003 and we are using 8 dual core processor.How to check "lock pages in memory" grant ?? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-06-16 : 10:28:05
|
| Check for Total Server Memory and Target Server Memory Counters for RAM utilization by SQL Server.As Tara said, You need to enable 'Lock pages in Memory' and Enable AWE and Set Min/MAX for Memory Settings in Server Properties in 32-bit System. |
|
|
|
|
|
|
RAM Utilisation