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”
This command is used to make a query to oracle using SQL Plus and a username/password/host. Prior you need to define Oracle enviroment variables. Module data Sample Oracle enviroments variables: export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server ...