Home > IT Answers > SQL Server > Procedure cache ratio calculation in SQL Server?
Db23
290 pts.
 Procedure cache ratio calculation in SQL Server?
SQL Server, SQL Server 2005, SQL Server stored procedures
Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.

Software/Hardware used:
ASKED: February 8, 2010  2:21 AM
UPDATED: February 11, 2010  5:01 PM
RELATED QUESTIONS
Answer Wiki:
You can get the amount of procedure cache in use, and the procedure cache hit ratio from perfmon or from the sys.dm_os_performance_counters DMV.
Last Wiki Answer Submitted:  February 11, 2010  5:01 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _