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 |
|
sparkt5
Starting Member
1 Post |
 Posted - 2009-05-11 : 16:38:15
|
| Server:32 Bit Windows 2003 server Enterprise Edition SP2Hot fix applied for performance degradation when moving large files.64 Gb of RAM showing in my computer properties with Physical Address Extention. The boot.ini file does not show PAE, but according to MSDN this is correct(http://support.microsoft.com/kb/283037)SQL Server32 bit SQL Server Standard Edition SP3 with AWE enabled and memory capped to 50 Gb.Page file is set to 12GbWhen the server is started page file shows about 5 Gb. It eventually creeps up to about 50 or more Gb at which point the SQL logfiles shows the following error.A significant part of sql server process memory has been paged out. This may result in performance degradation. User is allowed lock pages in memory (is this appropriate on 32 Bit?) & have followed http://msmvps.com/blogs/omar/archive/2007/09/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspxCan't get a handle on whats happening but performance is woeful on this system.Has anyone else experienced this problem? I can find lots of articles for 64 bit, but not 32.Any suggestions greatly recieved. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-11 : 17:11:34
|
The only statement I see where you WOULDN'T use the PAE switch is:quote:
Note In Windows Server 2003, PAE is automatically enabled only if the server is using hot-add memory devices. In this case, you do not have to use the /PAE switch on a system that is configured to use hot-add memory devices. In all other cases, you must use the /PAE switch in the Boot.ini file to take advantage of memory over 4GB.
I don't think it hurts to have the /PAE switch in there unless a Microsoft support tech tells you to remove it. I know I couldn't get my 16 GB server to work correctly until I added it. You definitely don't need the /3GB switch, just /PAE. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-11 : 22:19:23
|
| You should give user privileges to 'Lock pages in Memory'? Also don't enable /3GB switch if you are going beyond 16 GB. Post the Counter of:1) Total Server Memory2) Target Server Memory3) Pages/Sec4) Page Life expectancySo we can analyze. |
|
|
|
|
|
|
Windows & SQL 32 bit AWE & paging