Post reply

ERROR: "A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 92984, committed (KB): 1688060, memory utilization: 5%."

  • January 12, 2010 at 1:47 am

    #136541

    Hello, I have the following problem:

    "A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 92984, committed (KB): 1688060, memory utilization: 5%."

    I get this error every two-three minutes aproximatly, since 10 days ago. My server has the following caracteristics:

    Windows server 2003 Standar Edition SP2 (32bits)

    intel(R) Xeon(TM) CPU 3.6GHz and 3.5GB de RAM.

    SQL Server 2005 Standar Edition 9.00.3068.00 SP2 (32bits).

    SQL Server hasn´t allocated MIN nor MAX memory.

    I enclose two files with performance and administration task.

    How can I solve this problem??, which causes are??. It`s emergency.

    Thanks!!.

  • January 12, 2010 at 2:39 am

    #1102248

    probably you are facing a memory crunch. Can you check the following?

    under performance monitor(perfmon ) check the counter 'SQL Server Buffer: Buffer Cache Hit Ratio' for half an hour and provide the average value shown by perfmon.

    Regards,
    Raj

    http://Strictlysql.blogspot.com

  • January 12, 2010 at 2:42 am

    #1102252

    Just forgot to add if its less than 95% then yes its a memory crunch for sure. Ideal value is 99%

    Regards,
    Raj

    http://Strictlysql.blogspot.com

  • January 12, 2010 at 5:08 am

    #1102315

    I checked the counter 'SQL Server Buffer: Buffer Cache Hit Ratio' for an hour and the average

    value is 99,200 approximately.

Viewing 4 posts - 1 through 3 (of 3 total)

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