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...