Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by blog. Determining when corruption was introduced into a SQL Server database can be challenging, as corruption can occur without generating any obvious symptoms. However, there are some steps you can take to help determine when …
You only have until the end of the month to get this Database Health Monitor discount of 25% off. This month marks the anniversary of Database Health Monitor. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor but this deal is only good when you purchase before the end of July. …
Time is running out on this Database Health Monitor discount Read more »
Stedman Solutions, LLC, under the stewardship of Steve and his adept team, has crafted an innovative, email-based performance tuning course. With more than a year worth of training, this program is designed to optimize your SQL Server’s capabilities, offering weekly tips and techniques for enhanced performance. Join an elite community of subscribers endeavoring to inject newfound horsepower into their SQL …
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU14 for 2022 (16.0.4135.4 – July 2024) CU13 + GDR (16.0.4131.2 – July 2024) 2024-07-23 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: NoneCU14 …
Understanding SQL Server Isolation Levels When working with SQL Server, understanding isolation levels is crucial for ensuring data integrity and controlling how transactions interact with each other. Isolation levels dictate how transaction integrity is maintained, preventing issues like dirty reads, non-repeatable reads, and phantom reads. Let’s dive into the various isolation levels SQL Server offers and explore their differences and …
The SQL Performance Viewer is one of the many features in Database Health Monitor intended to help you find performance issues on your SQL Server. As part of Database Health Monitor month, I have put together this short video showing the SQL Performance Viewer in action. Just one of the many features of Database Health Monitor. Have you tried it …
Database Health Monitor – SQL Performance Viewer 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. PREEMPTIVE_OS_PIPEOPS MEMORY_ALLOCATION_EXT SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET ASYNC_NETWORK_IO CXSYNC_PORT LCK_M_SCH_S LCK_M_IX LCK_M_IS RESOURCE_SEMAPHORE_QUERY_COMPILE Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
With this month being Database Health Monitor month, I have received many questions about licensing, and the common question that has come up is “What are Connection Points?”Sorry for the confusion, I can help clear that up. Connection points are how licensing for Database Health Monitor is tracked. A connection point allows you to connect to one SQL Server Instance …
In today’s digitally-driven business landscape, ensuring efficient database management is paramount. It’s the backbone of smooth operations, enabling optimal user experience and robust business processes. With this in mind, Stedman Solutions presents the Database Health Monitor, a comprehensive tool that facilitates effective database management. This July, we are offering a remarkable opportunity: a 25% discount on the Database Health Monitor …
Boost Your Database Performance with Stedman Solutions’ Database Health Monitor Read more »
The goal at Stedman Solutions, is to create raving fans out of each client. “Just satisfied” is not enough for us. The raving fans page is where we share details on raves from our happy customers.Read what other Fans had to say Here is what a few raving fans had to say about Database Health Monitor. If you try Datababase …
Awesome app – What people have to say about Database Health Monitor Read more »