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 |
|
kusumjain
Starting Member
21 Posts |
 Posted - 2008-09-24 : 11:10:01
|
| New to DBA We have a SQL 2005 64 bit server with 32 GB Ram. Should I make it AWE Enabled.Should I keek the default settings for Min and Max memory, or how should I change the min and max memory.Any help is appreciatedThanks,Kusum Jain |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-24 : 11:16:33
|
| You don't need to enable AWE for 64-bit Server. PAE and boot.ini means nothing for it. You have to enable "Lock pages in Memory' so that you don't get Memory Paging out in Event Log. |
 |
|
|
kusumjain
Starting Member
21 Posts |
Posted - 2008-09-24 : 11:29:13
|
| Thanks for your quick reponse.Any idea on the Min and Max memory settings.Thanks,Kusum Jain |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-24 : 14:45:25
|
| Best way is to run Performance counters on Memory usage and you can set min and max memory depending on how much you want to allocate for OS and other apps(if exists). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Setting the Min and Max Memory for SQL Server