SQL Server Performance

buffer hit ratio

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by priyaram, May 22, 2007.

  1. priyaram New Member

    i am continusly getting the error message from sqlserver thru our server monitor

    "Group: SQL Server
    Status: 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...

  2. satya.sqldba New Member

  3. satya Moderator

    Ensure the ASP.NEt service is started or not.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    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.

Share This Page