Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  alert -Buffer cache hit ratio is lower than 90%

Author  Topic  inbs Aged Yak Warrior 860 Posts Posted - 2009-07-30 : 11:25:48 i add this alert(Buffer cache hit ratio is lower than 90%) and i get this message: DESCRIPTION: The SQL Server performance counter 'Buffer cache hit ratio' (instance 'N/A') of object 'SQLServer:Buffer Manager' is now below the threshold of 90.00 (the current value is 1.00). first how can i know what is size of buffer? how could it be that current value is 1.00 ?