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)
 Hi .. Need information reg buffer hit ratio

Author  Topic 

msaran45@gmail.com
Starting Member

1 Post

Posted - 2008-10-12 : 16:45:07
Hi ,

I need information reg buffer hit ratio problems and solutions. I am new to this database administration. please anyone clear my doubts

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-13 : 04:02:07
A buffer cache hit ratio of 100% is better than a buffer cache hit ratio of 80%.
A rule of thumb is that 90% is a decent threshold.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-13 : 04:29:50
http://www.rampant-books.com/t_hpsdba_60_ratio_analysis_techniques.htm
Go to Top of Page
   

- Advertisement -