Monitor Microsoft SQL Server, databases and performance with Zabbix, PowerShell, Performance Counters and WMI. Keep SQL Server and databases in top shape and performance up! In this post I show you how you can use Zabbix to monitor those important aspects for database administrators (DBA).
Use Zabbix to monitor your web application and application pool's .NET CLR Garbage Collected heap by utilizing WMI and PowerShell. Keeping track of .NET memory usage enables you to optimize usage and performance further.
WMI stopped working: WmiPrvse.exe would just crash after hitting some memory limit of 512 MB. If you run into the same issue with Windows Management Instrumentation, here is how you can increase WMI Provider Service’s memory quota. Doing so resolved my issues: learn to optimize WMI Provider Host.
This is part 3 about Zabbix monitoring for your websites and ASP.NET applications in IIS. This time I'll show you how to get data from Win32_PerfRawData_PerfProc_Process counter, fast, for everey application pool This counter is notorious for its slowness, but you can get data a bit faster. IIS AppPool Insights in Zabbix - because there is always more than one way.
Monitor ASP.NET web applications performance in Zabbix. Take advantage of Windows Server performance counters using Zabbix functions "perf_counter" and "perf_counter_en" in your templates.
Zabbix can harnas the powers of WMI (Windows Management Instrumentation) to query the Windows system for data. In Zabbix you use wmi.getall for this. Here is a small introduction to query the number of running w3wp.exe processes per IIS application pool in Zabbix.
Ever wanted to know the current number of active FTP client connections on your Windows Server IIS FTP Service? You can get this statistic using PowerShell, the Get-Counter cmdlet and the Microsoft FTP Service Current NonAnonymous Users performance counter.