Lazy Writes / sec

  • on one of my servers i checked the Lazy Writes / sec and i get a very very high value of 2635802.

    everywhere i read that this should be < 20

    is this a incremental value of last server start and i should get this value on intervals and find the difference or what?!

    this server has been online and never restarted for 18 months now. Meanning that everything works just fine but this is a counter that i had never looked at and wondering if this is some kinda memory problem.

    BTW its sql server 2008

    thanx

  • Found the answer to my own question.

    Yes it is as i suspected. It is incremental. So if someone would like to get this value you should run:

    declare @LazyPerSec bigint

    SELECT @LazyPerSec = [cntr_value]

    FROM sys.dm_os_performance_counters

    where [counter_name]='Lazy writes/sec'

    order by [counter_name]

    WAITFOR DELAY '00:00:05'

    SELECT ([cntr_value]-@LazyPerSec) / 5

    FROM sys.dm_os_performance_counters

    where [counter_name]='Lazy writes/sec'

    order by [counter_name]

  • Hi

    When this indicator is greater than 20, then it indicates a need for more memory. Yours is much greater than 20.

    Is your memory small?

    Check some more like Page reads/writes per sec, Page Life Expectancy, and some other Buffer manager and Memory performance counters.

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com

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

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