Home Forums SQL Server 2005 Administering Windows 2003 Enterprise Sp1/MSSQL 2000 Enterprise 8.0.2.39 Not able to Increase Target Server Memory RE: Windows 2003 Enterprise Sp1/MSSQL 2000 Enterprise 8.0.2.39 Not able to Increase Target Server Memory

  • Hi,

    Thank you all for the replies. I applied http://support.microsoft.com/kb/899761 hot fix to one of the active cluster instance and now am able to see more than 4GB for target server memory and total server memory in perf mon when I extend the max memory to over 4 GB. So the hotfix applears to be working!

    However, when I tried to install the same hotfix on another instance on the same cluster, the hotfix couldn't detect the active instance on that machine. The active instance didn't show up in the list for me to check and install. I looked at the hotfix installation log... it didn't report finding the active instance at all. I double checked the instance, it is running fine on that machine and it is patched to 2039 with sp4 as required by this hotfix.

    What could be wrong with this instance? How does the hotfix pick up the active instance information? By looking in the registry?Ps.the instance itself has been running fine and is one of our main production server.

    Thanks.

    Julie