indicates the percentage of times that the engine uses the disk cache front Module data SELECT CacheHitRatio FROM Win32_PerfRawData_MSSQL${dev/zSQLInstance}_MSSQL${dev/zSQLInstance}CacheManager WHERE Name=”_Total”
Number of user connections Module data SELECT UserConnections FROM Win32_PerfRawData_MSSQL${dev/zSQLInstance}_MSSQL${dev/zSQLInstance}GeneralStatistics
Number of times that cahe is used per sec. Module data SELECT CacheUseCountsPersec FROM Win32_PerfRawData_MSSQL${dev/zSQLInstance}_MSSQL${dev/zSQLInstance}CacheManager WHERE Name=”_Total”
Basic service monitoring for microsoft SQL Server 2000 in a windows pandora fms agent. Local module. Modules module_begin module_name msSQL Server 2K module_type generic_proc module_service MSSQLSERVER module_end
