Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Lazy Writes / sec Expand / Collapse
Author
Message
Posted Wednesday, May 1, 2013 6:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:46 PM
Points: 5, Visits: 60
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
Post #1448390
Posted Wednesday, May 1, 2013 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:46 PM
Points: 5, Visits: 60
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]

Post #1448392
Posted Wednesday, May 1, 2013 6:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 11, 2014 4:33 PM
Points: 2,948, Visits: 2,965
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,
SQL Server developer at Seavus
www.seavus.com
Post #1448395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse