Hi All< ?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I would appreciate any help from you all with regards to this:
I have a SQL 2005 standard installation with windows server 2003 enterprise Operating system
The server has 7GB of memory available to it, but as I know SQL 2003 standard edition would make use of the total server memory available to it.
Here are the changes that I have made. (I have converted it all to GB for easy reading)
I added the 3GB switch to the boot.ini file
I enabled AWE
I set mini server memory to 5GB
I set max server memory to 6GB
I turned on Performance monitor and the Target server memory counter = 6GB, the total server memory is also set to 6GB.
Now after all the changes above, the server seems to run slower and looking at task manager, the PF usage is around 6GB.
Can anyone please confirm that the changes I made were indeed correct and possibly educate me on the configuration and how to make the best use of server memory etc.
I look forward to hearing from you all.
John Burchel (Trainee Developer)