Jump to content

SQL Server Buffer Cache Hit Ratio

  • Please log in to reply
1 reply to this topic

#1 Guest_drosen10_*

  • Guests

Posted 30 November 2012 - 08:28 PM

I'm monitoring the SQL Server Buffer Cache Hit Ratio. Results are always numbers greater than 1 - sometimes much greater (1500, for example.)
A hit ratio should always be 1 or less, so what's happening here?

#2 Sergei Leonov

Sergei Leonov

    Advanced Member

  • Administrators
  • PipPipPip
  • 664 posts

Posted 05 December 2012 - 09:55 AM

We use the standard MSSQL counter. The SQL statement for this counter is
SELECT cntr_value
FROM sys.sysperfinfo
WHERE (object_name='SQLServer:Buffer Manager' OR object_name= (Select('MSSQL$'%2bconvert(varchar,SERVERProperty ('InstanceName'))%2b':Buffer Manager'))) AND counter_name ='Buffer cache hit ratio'
Sergei Leonov
WAPT Project Manager
SoftLogica LLC

Office: +7-383-335-6692
Toll-free: 1-888-364-6797 (for US only)
Time zone GMT +6, EST +11
E-mail: support@loadtestingtool.com

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users