Post reply

RAM in SLQ Server 2000

  • November 28, 2011 at 4:30 am

    #98161

    Hi,

    I have a server of Windows Server 2003 R2 SP2 with 2 GB of RAM, In task manager more than 1 GB of RAM always shows for SQLServer.exe.

    Is this default or something serious to my server ?

    Thanks in advance.

  • November 28, 2011 at 4:51 am

    #1413349

    beejug1983 (11/28/2011)

    Hi,

    I have a server of Windows Server 2003 R2 SP2 with 2 GB of RAM, In task manager more than 1 GB of RAM always shows for SQLServer.exe.

    Is this default or something serious to my server ?

    Thanks in advance.

    Is it 64 bit or 32 bit?

    Use perfmon.msc if its 32 bit.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 28, 2011 at 5:26 am

    #1413365

    its 32 bit. what counters i need to check.

  • November 28, 2011 at 6:02 am

    #1413380

    This is normal. When SQL Server reaches a particular level of memory uses, It doesn't release it back to operating system unless there is memory pressure. Check your max memory settings for the instance.


    Pradeep Singh

  • November 28, 2011 at 9:50 pm

    #1413759

    beejug1983 (11/28/2011)

    its 32 bit. what counters i need to check.

    Hello beejug1983,

    2 GB is very tiny one. nowadays the home system default memory configuration is 4 gb. And still you using SQL 2000 with 32 bit.

    Have a look SQL 2012 Licensing details.

    http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 30, 2011 at 10:05 pm

    #1415022

    Muthukkumaran,

    This is not my home PC its client server, I have noticed one strange thing on sever also. Page Life Expectancy continuously remaining 1100+ I just could not understand. Can you guys let me know the reason of it ?

    Thanks in advance.

  • November 30, 2011 at 11:00 pm

    #1415027

    beejug1983 (11/30/2011)

    Muthukkumaran,

    This is not my home PC its client server, I have noticed one strange thing on sever also. Page Life Expectancy continuously remaining 1100+ I just could not understand. Can you guys let me know the reason of it ?

    Thanks in advance.

    PLE of 1100+ means that an average page read into the buffer pool remain in memory for 1100 seconds (just under 2 hours). That is a good thing. It means that 2 GB of ram is more than enough and you don't need to upgrade to sql 2012.

  • November 30, 2011 at 11:41 pm

    #1415036

    beejug1983 (11/28/2011)

    Hi,

    I have a server of Windows Server 2003 R2 SP2 with 2 GB of RAM, In task manager more than 1 GB of RAM always shows for SQLServer.exe.

    Is this default or something serious to my server ?

    Thanks in advance.

    Muthukkumaran,

    This is not my home PC its client server, I have noticed one strange thing on sever also. Page Life Expectancy continuously remaining 1100+ I just could not understand. Can you guys let me know the reason of it ?

    Thanks in advance.

    PLE seems good and you don't have any memory problem.

    Is it 64 bit or 32 bit?

    Use perfmon.msc if its 32 bit..

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • December 1, 2011 at 4:04 am

    #1415130

    It is 32 bit, I read on MSDN if the PLE is more than thousand means there is much Memory for SQL Server to cache the data. But I dont have much memory as I mentioned I have only 2 Gig of RAM so how it is much enough for SQL ?

    Thanks.

  • December 1, 2011 at 5:34 am

    #1415181

    beejug1983 (12/1/2011)

    It is 32 bit, I read on MSDN if the PLE is more than thousand means there is much Memory for SQL Server to cache the data. But I dont have much memory as I mentioned I have only 2 Gig of RAM so how it is much enough for SQL ?

    Thanks.

    You are not understand my point. In 32 bit server the task manager will not give you clear picture. Use the Perfmon and check it out.

    There is nothing (no number) like that in PLE .The big value is good.

    Actually i'm not sure what's your problem?

    Do you have memory problem

    Or

    Do you want to reduce the memory

    Or

    Do you want to increase the memory

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply