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