February 9, 2009 at 9:15 am
In MOSS 2007 server, SQL server exe takes 7.5 GB out of 8 GB, if wee the performance of the computer in Windows task manager => Performance => PF usage, even if there are no web requests to the MOSS server.
Any idea what could be the reason
February 9, 2009 at 9:40 am
What's SQL version is installed on the machine, is there a max memory been set on SQL ???
February 9, 2009 at 9:46 am
Once SQL Server has grabbed the memory, which it will do for caching, it tends to hold onto it unless it's needed by other applications. And then it grudgingly lets go.
Is this 32 or 64 bit server? Is it affecting performance? If not, this is normal, and leave it alone.
February 9, 2009 at 9:47 am
You can get the above details by running the below
USE master
Go
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
Go
EXEC sp_configure 'max server memory (MB)'
GO
Sriram
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply