June 9, 2009 at 10:49 am
Looks like there is a memory issue on sql server.
I see following memory in the task manager.
Total physical memory is 32 GB
Available memory is 30 GB
In the memory tab, sql server is using only 4 GB. Looks like sql server is not using all the memory. I restarted the sql server and but problem is still there.
I also checked the sql server properties table and the memory allocated to sql server is 24GB minimum and 28GB maximum.
Appricated if anybody helps.
June 9, 2009 at 11:14 am
What kind of SQL server 2005 edition do you have? What kind of operating system do you have your SQL server installed?
June 9, 2009 at 3:52 pm
I just came to know that we should not rely on task manager when checking memory problem. Task manager sometimes does not give proper information on Itanium server.
We should use Performance Monitor to check memory issue. After checking Performance monitor, I don't see any problem in memory allocation.
Thanks for your help.
June 9, 2009 at 5:10 pm
Thanks for the update.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply