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 |
|
tradu81
Starting Member
3 Posts |
 Posted - 2010-08-08 : 21:22:44
|
| Hi,I was hoping someone could assist me.Our SQL server is reporting excessive memory utilisation issues. I was looking at perhaps adding nother 2 GB of physical Virtual memory and using the /PAE switch in the boot.ini file to allow the SQL application to use more memory.However, I found two articles one indicates Windows Server 2003 SP1 Standard can use this switch and the other has no mention.http://support.microsoft.com/default.aspx?scid=kb;en-us;274750http://support.microsoft.com/kb/283037/http://www.microsoft.com/whdc/system/platform/server/pae/paedrv.mspxMy current platform is below:O/S: Windows Server 2003 Service Pack 1 Standard edition (32 Bit)Memory: 4GB RAMSQL version: SQL Server 2000 Standard Edition (SP4)Hardware: VMware Virtual MachineI need to clarify whether it's possisble on the current platform from experience.Also, if I were to add the addition 2 GB of memory, with the PAE switch will this make any performance improvement on the server?I've never done this before.Thank you in advance. |
|
|
tradu81
Starting Member
3 Posts |
Posted - 2010-08-09 : 01:32:53
|
| I also used query analyzer via DBCC MEMORYSTATUS command.I found the buffer counts as follows:Commited: 206864Target: 206864Hashed: 153271Visible: 206864The database running on there is appro 11.7 GB is teh above memory allocation ok or does it appear to be a concern that Commited and target are the same? |
 |
|
|
|
|
|
SQL Memory allocation \PAE