February 16, 2009 at 10:11 am
Hi,
I have 64 bit SQL Server 2005 SP2 running on 4 GB RAM system with "network service" service account.
Task Manager shows that SQL Server consumes only less that 1 GB RAM.
Max Server Memory is set to 3 GB.
I am facing performance issues in this server.
Is there any suggestions Please?
Thanks in Advance,
prakashdgl
R
February 16, 2009 at 10:19 am
Are you sure that problem is in Sql server?
Do you have any other applications on that server?
You can set minimum server memory to 2 GB but I am not sure that this will resolve your performance problem.
You must go deeper with resolving performance problem, you should use performance counter not task manager.
Best regards,
February 16, 2009 at 10:50 am
Other thing to check is in the Local Group Policy Security Settings (Start/Programs/Administrative Tools/Local Security Settings) in the the Lock Pages (Local Policies/User Rights Assignment/Lock Pages in Memory). There you would add the user under which the SQL Service instance runs. It will allow it to lock the pages in memory and not be prone to Paging due to OS pressure.
On 64 bit systems the AWE setting has no effect, and I believe also the /3GB in the boot.ini does nothing....
Also, what you see in the Task manager, is just the memory used by the core sql.exe, which is not equal to the memory used by the sql processes. We have a 64GB system with SQL Max memory set to 56GB, yet the sql.exe process in the task manager only says 384MB....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply