Browsed by
Category: Microsoft

Getting Fancy with Log Insight Alerting (aka. Monitoring DHCP pools via logs)

Getting Fancy with Log Insight Alerting (aka. Monitoring DHCP pools via logs)

Recently, I was asked about monitoring Microsoft DHCP IP Address Pools using Log Insight to alert when the pool was exhausted and DHCP requests were failing. There are a couple ways to do this, but I’d like to cover two as a demonstration of getting a bit fancy with your alert queries and it paying off big time! First off, Microsoft DHCP Servers write their events to a log file – at the end of the day…. so we can…

Read More Read More

Corrupt Microsoft SQL Database Log in AlwaysOn High Availability Group (AAG)

Corrupt Microsoft SQL Database Log in AlwaysOn High Availability Group (AAG)

We recently ran into an issue with one of our environments where the Microsoft SQL Server experienced corruption in the database log. This issue is usually discovered when you attempt to create a new backup and it fails with the message “BACKUP detected corruption in the database log” Resolving this issue is normally fairly easy (set the database from a Full Recovery Model to simple and then back again) but it gets a bit more complex when you database is…

Read More Read More

FreeTDS and Microsoft SQL Server Windows Authentication – Part 1

FreeTDS and Microsoft SQL Server Windows Authentication – Part 1

I’ve been trying to get the Zenoss SQL Transaction Zenpack working so that we can use Zenoss to run SQL queries for specific monitoring purposes and ran into a few things that might be worth sharing. Using tsql for troubleshooting Zenoss, among many other tools uses pymssql to connect to your SQL Servers; and pymssql uses FreeTDS behind the scenes. If you can’t get pymssql to work them you can go a layer deeper to see if you can find…

Read More Read More

Early Boot Windows Debugging – Part 2 – Kernel Debugging over Serial

Early Boot Windows Debugging – Part 2 – Kernel Debugging over Serial

This post is a continuation of Part 1; I think I shall call it “Help, my ntbtlog.txt isn’t being written to disk and I’m flying blind” Ok, now I need more data because I’m not getting anywhere. Fortunately Windows still has the option to log kernel debugging over serial. A feature I wasn’t aware existed util today. That brings up the big question: how do I make that work on a VM and a physical device without a serial port?…

Read More Read More

Early Boot Windows Debugging – Part 1 – Basics

Early Boot Windows Debugging – Part 1 – Basics

I have a Windows Server 2012 VM that will not boot past the Windows splash screen but throws a BSOD with the error “SYSTEM_THREAD_EXCEPTION_NOT_HANDLED (NETIO.SYS). It’s been a long while since working on troubleshooting Windows (I primarily use CentOS) but here’s what I’ve found. I don’t have the solution yet but I’m recording some tidbits that I found so I will have them later. First a bit of preamble: 1. Advanced Boot Options – When you select “Enable Boot Logging”…

Read More Read More