Last time, I talked about the issues with trying to get a server to monitor itself for downtime. In part 2 of this series, I’ll talk about my solution for monitoring. In the final part, I’ll discuss how to use the logged data for reporting. Part 1 can be found here. Part 3 can be […]
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 […]
[UPDATE Oct 2013]: I have made some improvements to this script, including those mentioned in the comments below. See my post on 10/28/13 for the latest version. I recently posted an update of my script to enable data compression in SQL Server, but I’ve made some significant changes recently and decided it was time to […]
I’ve created a 4.5+ hour online training course for new, junior, and involuntary DBAs! If you are new to SQL Server or are responsible for maintaining SQL Servers but do not have a database background, this course is for you! Normal cost if $99, but the first 100 people to use the coupon code Aug50 […]
Back in March, I wrote about a method I use to enable data compression on a database and periodically re-scan for new tables to compress. This method worked fine on the database I was working with at the time. However, I have since tried to run this on a much larger database and the performance […]