TECK SYSTEM SOFT

supervision Cloud

Maintenance informatique

Administration, supervision, inventaires et gestion des incidents informatiques.

Application monitoring

Supervision applicative

Accedez rapidement au statut de toutes vos applications depuis votre PC, tablette ou telephone.

freeware for monitoring

Services Cloud

Le statut de votre informatique disponible 24/7 sur votre portail SaaS.



How to monitor SQL Server Supervision applicative | Maintenance informatique | Gestion des incidents informatiques | Logiciels de supervision gratuits

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 instanc(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