Uncategorized

In the intricate realm of database management, a significant challenge that often flies under the radar is the effective management of indexes. While these indexes can be a boon to query performance, an overabundance can hinder operations like inserts, updates, and deletes. This blog post delves into the nuanced world of index management, offering strategies to trim the unnecessary without destabilizing your system. Need help with this, try a free no risk 30 minute consultation with Steve Stedman. Navigating the …

The Art of Balancing Index Management in Database Performance Optimization Read more →

The Importance of a SQL Server Performance Assessment by Stedman Solutions We start with a free 30 minute consultation to determine how to best help with your SQL Server needs. Keeping Your Server in Prime Condition In the fast-paced world of technology, the performance of your SQL Server is pivotal to the smooth operation of your business. Regular performance assessments are essential, and Stedman Solutions offers a service that can not only keep your server in shape but also help …

SQL Server Performance Assessment by Stedman Solutions 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. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health 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. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health Read more →

As we cross the midpoint of July, it’s time to shift our focus onto the life force of our digital existence – our databases! Being the founder of Database Health and Stedman Solutions, it brings me immense joy to pronounce July as Database Health Monitor Month! This is our yearly chance to acknowledge our largely invisible data protectors, and to plunge into the heart of our systems, rich with intricate data structures and complex relations. The moment has arrived for …

Just past the midpoint of Database Health Monitor Month 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. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health Read more →

Shrinking a database can seem like a helpful way to save space and resources, particularly if a database has grown substantially over time. However, SQL Server’s default maintenance plans that include database shrinking can lead to several performance issues. Here’s why: Fragmentation: When a database is shrunk, the data pages are reorganized to create a contiguous block of free space at the end of the data file, which can cause severe fragmentation. This fragmentation can significantly degrade the performance of …

Database Health Quickscan – Default maintenance plans to shrink database – Ouch Read more →

Welcome to July – a month that signifies a shift in focus to the unseen heroes of our digital infrastructure – our databases. As the founder of Database Health and Stedman Solutions, it is with great pleasure that I announce this month as Database Health Monitor Month! This annual event allows us to appreciate our precious data, explore the intricacies of our systems, and focus on enhancing the health of our databases. This July, let’s not merely keep our databases …

Celebrating Database Health Monitor Month 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, and to dive deeper into the heartbeat of our systems, replete with intricate data structures and complex relations. It’s time …

Sneak preview – July is Database Health Monitor Month Read more →

Over the years developing Database Health Monitor I have added a number of keyboard shortcuts to make life easier when working in the application. Some of these are listed here to share since they are not all completely obvious. Backspace Key – Jump to the last report viewed The Backspace key can be used to jump to the previous report that you were viewing. Not just that, but hit it multiple times and you can browse back through the history …

Keyboard Shortcuts for Database Health Monitor Read more →