When I started working with SQL Server Always On Availability Groups several years ago, one of the most common questions I got was how to monitor the entire infrastructure. When it was a simple standalone SQL Server instance, monitoring was easy – you monitor if the SQL Server service was up or down, if the […]
In a previous blog post, I wrote about why it is important to have a methodology in place for monitoring your IT assets. In this blog post, I’ll discuss what a baseline is and why it matters. Two years ago, I’ve switched my car insurance provider in an attempt to lower down my monthly expenses. […]
As an IT professional – whether you be a database administrator, a systems engineer, a storage administrator, a network administrator, developer, etc. – the one thing that we need to get a good grasp on in our day-to-day task is MONITORING. Whether we like it or not, monitoring is part of our daily life. I […]
In a previous blog post, I mentioned why regularly shrinking your databases is not the right way to reclaim space. I also mentioned at the end of the blog post that the proper way to deal with database space issues is to monitor your disk space utilization and do proper capacity planning. That’s where tools like […]
A couple of weeks ago, I did a webcast for my friends at MSSQLTips about the top 5 things that every SQL Server DBA should monitor. If you’ve been to one of my presentations, you will notice that I usually focus on the WHY behind the topic. Understanding our overall goal makes it easy for […]