SQL Server Performance Forum – Threads Archive
buffer hit ratio
i am continusly getting the error message from sqlserver thru our server monitor "Group: SQL ServerStatus: Buffer cache hit ratio n/a, Cache Hit Ratio n/a, Average Wait Time (ms) n/a…" when i looked into the message in detail
The Open Procedure for service "ASP.NET_2.0.50727" in DLL "C:WINNTMicrosoft.NETFrameworkv2.0.50727aspnet_perf.dll" failed. Performance data for this service will not be available. Status code returned is data DWORD 0. i am not sure where this from… thanks
Look at the following: http://support.microsoft.com/?id=300956 Also refer to: http://www.eventid.net/display.asp?eventid=1008&eventno=70&source=Perflib&phase=1 Hope this helps Satya
Ensure the ASP.NEt service is started or not. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>