please suggest me

Question

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

- 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

CarpenterBob Ten Centuries Points: 1006 More actions · Answer 2

innovative0003 Grasshopper Points: 11 More actions · Answer 3

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

--------------------------------------------------------------------------------------------

Etalagemateriaal[/url]

Stoepborden[/url]

Folderbakjes[/url]

RTaylor2208 SSChampion Points: 13296 More actions · Answer 4

Have you tried

select * from sys.dm_os_performance_counters

where counter_name = 'Buffer cache hit ratio'

MCITP SQL 2005, MCSA SQL 2012