Using Powershell to Deploy Performance Monitor
As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight into what’s changed when performance is suddenly in the toilet. They can also provide a basis for determining what systems can be consolidated, downsized, or virtualized, which has become quite the topic of discussion with [...]
February 13, 2012
Tags: performance, powershell, scripts, SQL Server Posted in: Powershell 
2 Comments
Optimizing Backup Performance
If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are reserved for data, logs, and tempdb. So it’s up to us squeeze every last bit of performance out of our backup jobs. If you’re using maintenance plans to do your backups, chances are you’re not [...]
November 22, 2011
Tags: backup compression, backups, performance Posted in: Maintenance No Comments
Panic, Problems, and Plans
So what have I been up to? Well not writing blog posts, obviously. Everybody Panic!!! Really though, I haven’t exactly been slacking off these past couple weeks. As you may recall, one of my goals this year was to present at a SQL Saturday. To help me towards that goal, I have my very first [...]
September 14, 2011
Tags: MARS, performance, presenting, SQL Saturday, troubleshooting Posted in: General, Professional Development, Troubleshooting No Comments
EXECSYNC progress
I’m happy to report that some progress has been made on my performance problem. I’m still working on it, and there will be a full progress report to come, but for now I’m simply happy to say I’ve gotten somewhere in the EXECSYNC dept. Now, that’s not to say I’ve gotten rid of them, but [...]
September 1, 2011
Tags: execsync, index spool, performance, troubleshooting Posted in: Troubleshooting One Comment
This will make a great blog post someday…
Ever have one of those days when you feel like you know absolutely nothing? That pretty much sums up the past week for me. I’ve been fighting with a performance problem and have come up empty on all fronts. WTF? We’re in the middle of a project to upgrade one of our financial databases. The [...]
August 29, 2011
Tags: execsync, performance, waits Posted in: Troubleshooting 5 Comments
