TECK SYSTEM SOFT

IT Supervision

Global solution

Cloud dashboard, server monitoring, inventories and incident management.

Application monitoring

SaaS supervision

Server monitoring and inventories made easy as never, display status of all your applications from your PC, tablet or mobile phone.

freeware for monitoring

Cloud services

Your information available 24/7 on our Datacenters partners.



How to monitor SQL Server Freeware monitoring tools | SaaS monitoring | Help desk

How to monitor Microsoft SQL & SSRS servers

Overview




MonitorPack Guard computer needs a quick configuration, just follow these few steps or download MonitorPack documentation. this has to be done only once in your company infrastructure.

MonitorPack team provides regular useful metrics to easily monitor your Windows servers. These are basic metrics, if you want to go deaper, keep in mind that MonitorPack is able to check any existing performance counters, services, process, winsocks, shares and EventID in your monitoring, for more information for Windows server monitoring have a look at http://technet.microsoft.com/en-us/library/cc671175(v=exchg.80).aspx

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

How to monitor SQL servers (any version) with MonitorPack Guard at no cost




Open MonitorPack Guard > Expand Monitoring menu > Select manage Alerts. In the MonitorPack Guard manager panel select your alert type and select "create a new alert"

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

ID Performance counters alert 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 Windows processes alert 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