November 12, 2009 at 4:44 am
We have SQL Server 2005 Enterprise Edition (X86) on Windows Server 2003 (X86). The server has 32Gb of RAM on it and I see that, by default, SQL Server will only use 2Gb (appears as 1.67Gb in taskmgr).
Is it a good idea for us to enable AWE to allocate memory so that it can use more of the 32Gb available? And if so, what would be a good recommendation for the max memory setting?
The server is a dedicated database server used for housing a 100Gb data warehouse.
Thanks,
Andy
November 12, 2009 at 5:11 am
You need to enable AWE if you want sqlserver to use more than 8GB of ram.
have a look at:
- http://sqlserver-qa.net/blogs/perftune/archive/2007/12/28/3048.aspx
- http://support.microsoft.com/default.aspx/kb/274750
- BOL ref: http://msdn.microsoft.com/en-us/library/ms190673%28SQL.90%29.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 12, 2009 at 5:37 am
ok thanks. So obviously it is a good idea then.
November 12, 2009 at 5:57 am
just keep in mind to set "max server memory" to the amount of ram you allow it to use on the box.
Leave enough ram for the other processes running on it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply