July 14, 2011 at 7:01 am
July 14, 2011 at 7:03 am
http://www.bing.com/search?q=what+is+SQL+Server+Buffer+Cache+hit+ratio
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 14, 2011 at 9:50 am
August 5, 2011 at 6:55 am
Hello,
Is it possible to capture buffer cache hit ratio using t-sql script:
I am going to try this:
declare @num float
declare @dec float
select @num = cntr_value from master..sysperfinfo where object_name = 'SQLServer:Buffer Manager' and counter_name = 'Buffer cache hit ratio'
select @dec = cntr_value from master..sysperfinfo where object_name = 'SQLServer:Buffer Manager' and counter_name = 'B
Buffer cache hit ratio base'
select cast( @num*100/@dec as numeric(5, 2))
Let me know if anybody has tried this way of capturing BCHR.
Best Regards,
displaywinkel
--------------------------------------------------------------------------------------------
August 5, 2011 at 9:47 am
Have you tried
select * from sys.dm_os_performance_counters
where counter_name = 'Buffer cache hit ratio'
MCITP SQL 2005, MCSA SQL 2012
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply