.::: Add Sensor Microsoft SQL V2, Sensor Factory PRTG to Monitoring CPU Memory SQL Server :::.

 

continue from https://teguhth.blogspot.com/2024/03/script-check-cpu-usage-memory-usage.html

A. Configuration to PRTG
1. create file query
 

2. copy query to directory
C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\sql\mssql
 

3. Create Add Sensor using Microsoft SQL V2 & add User access

 
 

4. sample collect CPU Utilization (%)
Sensor Name: CPU Usage
Database : teguhth
SQL Server Instance : blank or your instance
Instance Name
SQL Query File : sp_total_usage_cpu_SQLProcessUtilization.sql
Data Processing : Process data table
Channel #1 Name : CPU Usage(%)
Channel #1 Column Number : 0
Channel #1 Unit : Persent
Primary Channel : CPU Usage(%)
 

5. sample colect Memory Utilization (%)
Sensor Name: MemUsage(%)
Database : teguhth
SQL Server Instance : blank or your instance
Instance Name
SQL Query File : sp_total_usage_memory_SQL_percent.sql
Data Processing : Process data table
Channel #1 Name : MemUsage(%)
Channel #1 Column Number : 0
Channel #1 Unit : Persent
Primary Channel : MemUsage(%)
 

6. sample collect Memory Utilization (MB)

Sensor Name: Memory Usage (MB)
Database : teguhth
SQL Server Instance : blank or your instance
Instance Name
SQL Query File : sp_total_usage_memory_SQLProcessUtilization.sql
Data Processing : Process data table
Channel #1 Name : Memory Utilization
Channel #1 Column Number : 0
Channel #1 Unit : custom
Channel #1 Custom Unit : MB
Primary Channel : Memory Utilization
 

7. sample collect CPU memory Utilization using Senseor Factory

 

Sensor Name : CPU Memory Utilization
Channel Definition :

Channel Definition:
#1:CPU Usage SQL
Channel(2079,3)
#2:Memory Usage SQL
Channel(2078,3)

Primary Channel: CPU Usage (%)
 

B. Result Monitoring

1. CPU Utilization (%) with Sensor Microsoft SQL V2

 

2. Memory Usage Utilization (%) with Sensor Microsoft SQL V2

 

3. memory Usage (MB) with Sensor Microsoft SQL V2

 

4. CPU, Memory Utilization with Sensor Factory