This is a policy for monitoring SQL Servers. Modules generated by the policy: Avg. Disk sec/Read Avg. Disk sec/Write MS SQL Server status SQL_% Used Paging File SQL_Batch Requests/sec SQL_Buffer cache hit ratio SQL_Checkpoint pages/sec SQL_Compilations/sec SQL_Locks...
Plugin for monitoring SQL Server databases through custom SQL queries.Obtains the result of the launched SQL query as a value for the modules that use it. Documentation EN SQL Querier Tool ES SQL Querier Tool Only enterprise users can view the download...
SQL Server performance plugin This is a vbs plugin to fetch the performance metrics from a SQL Server. To install it: 1. Create the directory “%Program Files%pandora_agentplugins” if needed. 2. Download the file “sqlserver_plugin.vbs”. 3. Copy...
This script can monitoring a SqlServer using MSSQL Querys. Example: “<PowershellPATH>powershell.exe” querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q ‘MSSQL Query’ If you run as Administrator the...
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”