Analysis of your IT infrastructure

Home
Supervision incidents management Reporting services Inventories
Monitorpack Guard Monitorpack Snmp
Monitorpack Discovery Pricing & subscriptions Open a ticket Online support
Downloads Enterprise Contact ☰


Monitorpack











How to monitor Microsoft SQL & SSRS servers

The Monitorpack team regularly provides useful metrics to easily monitor your applications, devices and systems. These are basic measurements, if you want to go further Monitorpack software Guard is able to check all performance counters, services, processes, ports, event IDs, existing printers and shares in your IT environment.

Action Script alert Description How What
1 SQL server restart SQL services with net start command Monitorpack script alert Your script

How to monitor SQL servers


Open Monitorpack Guard > in the left panel select [ Create Alerts ] and select your alert type.

This example is for SQL Express version, it means that you have to adapt the value with you specific instanc(s) for Windows services and Performance counters

ID Performance Instance Rule Value
1 \MSSQL$SQLEXPRESS:Buffer Manager \Buffer cache hit ratio < 85
2 \SQLAgent$SQLEXPRESS:Statistics \SQL Server restarted > 1
3 \MSSQL$SQLEXPRESS:SQL Statistics \SQL Compilations/sec > 100
- - - - -
ID Process Process name When Status
1 sqlservr.exe sqlservr.exe Stopped True
2 sqlbrowser.exe sqlbrowser.exe Stopped True
ID Windows services alert Service name When Status
1 SQL Server MSSQL$SQLEXPRESS Stopped True
- - - - -
ID Windows Socket Socket name Port Value
1 SQL Server Database access 1433 False
2 SQL Server Agent browser 1434 False
ID Windows shares Share name Share Value
1 Share SQL SQLEXPRESS Stopped True
- - - - -
ID Windows printers Printer name Port Status
- Not Apply Not Apply Not Apply Not Apply
- - - - -
ID Windows Events Journal Name Level Source Event ID
1 SQL SSRS Application Error Report Server Windows Service (SQLEXPRESS) 107
2 SQL Logon failed Application Error MSSQL$SQLEXPRESS 17806