In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index …

Dangers of Removing Indexes Read more »

With years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. With this month being Database Health Montior month we have a special combo offering. I created the Database Health Monitor course to help people get the most value out of using the product, and with …

Database Health Monitor with Coaching Read more »

Today, I’m back to spotlight a deal that’s genuinely too good to ignore, especially if you’re in the realm of SQL Server management. We’re down to the final week of October, and Stedman Solutions is closing in on our exclusive offer. We can help!https://stedman.us/performance What’s The Deal? Until the end of October, if you purchase a SQL Server Assessment from …

Last Call: Just One Week Left for a Phenomenal Deal from Stedman Solutions! Read more »

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP ASYNC_NETWORK_IO LCK_M_IS OLEDB LCK_M_IU LCK_M_IX MEMORY_ALLOCATION_EXT LCK_M_S XE_LIVE_TARGET_TVF Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

Hello, I am Steve Stedman, a SQL Server expert, and I want to introduce you to my product, the Database Health Monitor for SQL Server. As a database administrator, I know how important it is to keep your database environment running smoothly. The Database Health Monitor for SQL Server is a powerful tool that provides real-time monitoring and alerting to …

Database Health: Must-have tool for any SQL Server database administrator Read more »

Hey there, Steve Stedman here, and I couldn’t be more excited to share some insights on a service that has been making waves in the world of database management. Today, I want to shine a spotlight on Stedman Solutions’ exceptional SQL Performance Tuning service, which has helped countless businesses optimize their database performance and streamline operations. https://stedmansolutions.com/services/sql-performance-tuning/ Still not sure? …

Unlocking Database Performance: Unleash the Power with SQL Performance Tuning Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2008 None 2023-10-17 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU9 for 2022 (16.0.4085.2 – October 2023) CU8 + GDR (16.0.4080.1 – October 2023) …

New SQL Update from Microsoft Read more »