Dec 20, 2017 | Application monitoring, Databases category, Enterprise, msSQLServer
SQL Server monitoring CPU_Busy – InstanceName, CPU_Timetick – InstanceName Idle Time – InstanceName, IO_Busy – InstanceName Input Packets Read – InstanceName, Input Packets Sent – InstanceName Instance Status – InstanceName, DatabaseName Status – InstanceName Packet...
Dec 18, 2017 | msSQLServer
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 it to the previosuly created...
Dec 18, 2017 | msSQLServer
This script can monitoring a SqlServer using MSSQL Querys. Example: "powershell.exe" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query' If you run as Administrator the script, and your sql account has permissions too,...
Dec 14, 2017 | Application monitoring, Databases category, msSQLServer
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"
Dec 14, 2017 | Application monitoring, Databases category, msSQLServer
Module data SELECT FullScansPersec FROM Win32_PerfRawData_MSSQL${dev/zSQLInstance}_MSSQL${dev/zSQLInstance}AccessMethods
Dec 14, 2017 | Application monitoring, Databases category, msSQLServer
Number of user connections Module data SELECT UserConnections FROM Win32_PerfRawData_MSSQL${dev/zSQLInstance}_MSSQL${dev/zSQLInstance}GeneralStatistics
