Availability Monitoring – Part 1

This is part 1 of a three part series on using home-grown up time monitoring for your SQL Servers. Part 2 can be found here. Part 3 can be found here. I was recently asked by my company’s management to provide some key performance indicators (KPIs) for our critical SQL Servers. One of the KPIs […]

They Don’t Always Know Best Part 2

Last week I wrote about some bad programming I discovered in Solarwind’s Orion monitoring software. One of their maintenance utilities reindexed the tables in the database, then performed a database shrink. This immediately creates about 100% index fragmentation. I don’t mean to pick on Orion, but I have been doing some more digging and discovered […]

They Don’t Always Know Best

This post contains details about the behavior of one particular program we use here at my work, but the general idea should be applicable anywhere. The IT department at my work, of which I am a part, uses a tool called Orion by Solarwinds Software for network performance monitoring. The software uses SQL Server as […]