Drive Space Monitoring Page

Updated: February 22, 2012 Some time ago, I wrote and published a routine to gather disk space usage from multiple SQL Servers. Since that was written, I’ve made some bug fixes and modifications to the routine. Tracking down those changes was becoming tedious, as they were spread out over several blog posts. I’ve decided to […]

“Drive Space Monitoring Gets An Update” Bug Fix

A couple of months ago, I created a routine to gather disk drive space statistics from several SQL Servers. Today, I discovered a bug in that program that could cause the @@SERVERNAME variable on the server that runs the job to get reset to NULL after a restart of SQL Server. The problem comes from […]

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 […]

“Drive Space Monitoring Gets An Update” Update

A while back, I wrote an article that appeared on that presented a routine to gather disk usage data for all the SQL Servers in an organization. One of the pieces of data that routine gathered was the size of the SQL Server data and log files and the total size of the drives […]