WMI Archives

Monitor SQL Server and databases in depth using Zabbix

Windows Server / By Jan Reilink / 20/12/2022

SQL Server performance monitoring in Zabbix: Keeping your SQL Server and databases in top shape is key for a good performing SQL Server database server and its databases. A good performing server makes happy customers, and that’s what puts bread on the plank, right? In this post I’ll show you how you can use Windows Performance counters, PowerShell and Zabbix for in depth monitoring of your SQL Server server and SQL databases.

…

Monitor SQL Server and databases in depth using ZabbixRead More »

Increase WMI memory to support large volume of queries

Windows Server / By Jan Reilink / 30/08/2021

Since I started expanding my Zabbix scripts and templates for monitoring Windows Server instances – AD, IIS and SQL Server – I found WMI was failing more and more. 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.

…

Increase WMI memory to support large volume of queriesRead More »

Getting more out your Windows Performance Counters monitoring for web applications – part 3

Windows Server / By Jan Reilink / 14/04/2021

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.

…

Getting more out your Windows Performance Counters monitoring for web applications – part 3Read More »

Monitor IIS application pools in Zabbix, part 1

Windows Server / By Jan Reilink / 27/02/2021

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 application pool in Zabbix so you can start monitoring Microsoft Windows Server IIS with Zabbix.

…

Monitor IIS application pools in Zabbix, part 1Read More »

WMI Filters for Group Policy to manage Windows Server versions

Windows Server / By Jan Reilink / 27/01/2020

This post contains some example WMI filters for you to use in Group Policy Objects (GPOs) to target and manage specific Windows Server versions like 2012R2, 2016 and Windows Server 2019. Using the Windows Management Infrastructure, or WMI, Windows admins can create filters to apply GPOs more granular on specific versions of Windows Server. In this post I provide some basic examples.

…

WMI Filters for Group Policy to manage Windows Server versionsRead More »

How to detect ethernet network speed in Windows

PowerShell / By Jan Reilink / 12/05/2017

Detect the ethernet network speed using PowerShell or WMI is perfect for Windows Server Core. If you ever need to lookup the speed of your ethernet network card in Windows, on the command-line, use one of the following WMIC commands on your PowerShell prompt:

…

How to detect ethernet network speed in WindowsRead More »

WMI/netsh to add DNS servers on network adapters

Windows Server / By Jan Reilink / 12/12/2014

Image of a phone book. Domain Name Servers (DNS) are the Internet's equivalent of a phone book

How to add DNS servers -or resolvers- to a Windows Server network adapter, or interface using WMI and the netsh command annd PowerShell. This one is quite old but may come in handy sometimes. In this example we use Google’s Public DNS server addresses and localhost to add as DNS Servers on our server’s interfaces.

…

WMI/netsh to add DNS servers on network adaptersRead More »