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 […]
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 […]
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 […]
I ran into an interesting situation this morning. I got alerts for each of my mirrored databases that they had entered the “Synchronizing Principal” state. (I wrote about how to set up these alerts here.) These alerts were sent from the principal server. There were no alerts from the mirror server, which should have happened […]
In this post, I walk through the steps of basic index analysis and, although we end up with a fairly obvious solution, we discover that optimizing SQL Server performance sometimes doesn’t even involve SQL Server. One of the occupation hazards, if you will, of being a DBA, is that you tend to think about possible […]