Monitoring is another important preventative measure that can help ensure the ongoing health and performance of a SQL Server. Administrators should monitor various performance metrics such as CPU usage, memory usage, disk usage, and network traffic to identify performance bottlenecks and potential issues. Monitoring can also help detect and resolve issues related to query performance, execution plans, and blocking sessions. …

Monitoring your SQL Server Read more »

Hey there! Steve Stedman here, founder of Database Health Monitor, and I’ve got something exciting to share with you. If you’re tired of dealing with slow database performance and unexpected downtime, then you’re in the right place. Let me introduce you to our game-changing class that will transform the way you manage and monitor your databases. Here is the deal:Use …

Database Health Monitor Class Deal Read more »

Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the …

Blocking Query Monitor – Part of Database Health Read more »

Ad hoc distributed queries are a feature of SQL Server that allow you to execute a T-SQL statement against a linked server. A linked server is a server that has been defined in SQL Server and that can be used to access data from other data sources. Ad hoc distributed queries can be a security risk because they allow users …

Securing SQL Server: Disable Ad-hoc Distributed Queries Read more »

Hi there, I’m Steve Stedman, the creator of Database Health Monitor, and I’m thrilled to bring you our groundbreaking class. If you’re tired of dealing with sluggish database performance and unexpected downtime, then this class is tailor-made for you. Join me on this exciting journey as we revolutionize the way you manage and monitor your databases. In the Database Health …

The Database Health Monitor Class: Your Key to Optimal Database Performance! Read more »

July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this month as Database Health Monitor Month! This is our annual opportunity to appreciate the often-unseen guardians of our valuable data, …

July is Database Health Monitor Month Read more »

This month marks the anniversary of Database Health Monitor, that I started building in 2011. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor. As many of you know, maintaining healthy and high-performing databases is critical for any organization that relies on data to drive business decisions. And that’s precisely what …

Early release – July is Database Health Monitor Month Read more »