From: "sysadmin.rock[SINESTO]"@gmail.com   
      
   On 07-09-2011 4:29, Erland Sommarskog wrote:   
   > Wishmaster ("sysadmin.rock[SINESTO]"@gmail.com) writes:   
   >> PF: Page File Usage   
   >   
   > Preferrably, SQL Server should not use the page file at all. OK, so that   
   > is probably a metric you see in Task Manager, but it's an odd way of   
   > expressing it.   
   >   
   >> Server specs: IBM X3650   
   >> -Intel Xeon X5450 3 Ghz   
   >> -6 GB RAM   
   >> -MS Windows Server 2003 R2 (Enterprise.Ed) SP 2   
   >> -SQL Server 2005 Enterprise Ed.   
   >>   
   >> Awe is not enabled.   
   >   
   > Is that 64-bit or 32-bit SQL Server? The number of 2GB makes me think that   
   > you have 32-bit SQL Server, and in that case you have some memory you are   
   > not using (unless there are other applications running on the server as   
   > well.) I would recommend that you enable /PAE in BOOT.INI and enable   
   > AWE and set max server memory to 4GB.   
   >   
   > I would also recommend that you install Service Pack 4 of SQL Server.   
   >   
   Yes, is a 32-bit sql server.  It's estrange but this server it is the   
   only one whitout AWE enabled. It has a SQL server SP3.   
   On Windows system properties shows 6,00 GB (PAE) but there is no   
   evidence of that in BOOT.ini (how it's that possible?)   
      
   I'm going to check sp4.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)