May 1, 2013 at 6:31 am
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
May 1, 2013 at 6:44 am
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]
May 1, 2013 at 6:47 am
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