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 […]
A couple of years ago, when my friend SQL Server MVP and Microsoft Certified Master Amit Bansal (Twitter | Facebook) delivered a high availability training in Singapore, I asked if I could take a look at the course outline so I can justify attending. Back then, I was responsible for managing several SQL Server 2000 […]
In a previous blog post, I talked about the importance of using the CHECKSUM keyword in the BACKUP DATABASE command to make sure that you are not caught unaware of page corruption in your backups. I’ve also provided a very simple example of showing how this one keyword can influence whether or not you’ll have a good […]