By Posted on Posted in Performance No Comments

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 ASYNC_NETWORK_IO CXPACKET OLEDB SP_SERVER_DIAGNOSTICS_SLEEP XE_LIVE_TARGET_TVF LCK_M_SCH_S CXCONSUMER LCK_M_X Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

By Posted on Posted in Performance No Comments

Steve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What You Get: Free weekly emails …

Exclusive SQL Performance Tuning Training Read more »

By Posted on Posted in Backup, Recovery No Comments Tagged with , , , ,

Current SQL Server course coupon codes and on going deals you can only get from Stedman Solutions! See All Our Online Courses! On Going Deals you can only get from Stedman Solutions FREE JOIN types reference sheet Free Ransomware / Cyber Attack Awareness Course Free Database Comparison Tool Free SQL Server CTE Book

By Posted on Posted in Backup, Recovery No Comments Tagged with , , ,

With 30+ years of DBA experience I will tell you first hand that Benjamin Franklin was a smart man! His quote, “If You Fail to Plan, You Are Planning to Fail” really hits home when you’re database is broken, lost or stolen. And we see this too often! Most recently the culprit has been ransomware but that’s no excuse for …

A Closer Look at the Backup and Recovery Course Read more »

By Posted on Posted in Backup, Corruption, Recovery No Comments Tagged with , , , ,

At Stedman Solutions, LLC when we do corruption repair it usually means someone has discovered they have corruption, and they call us. If they had good backups and good CheckDB scripts, they wouldn’t have to call us because they would have known when the corruption happened and likely been able to restore from backup or restore and replay transaction logs …

Importance of Backups Relating to a Corrupt Database Read more »

By Posted on Posted in Performance No Comments

New Giveaway Starting Soon Fri, 26 Aug 2022 Another #Giveaway starts on Monday! Newly launched products are out and we want to share! Next up are these fun socks with the Database Health Monitor logo pattern. Simply RETWEET the “official” giveaway post and tune Sept 16th to se Read more… August Database Health Monitor Version Release Wed, 17 Aug 2022 …

August Blog Post Wrap-up Read more »

By Posted on Posted in Database Health No Comments Tagged with , ,

Another #Giveaway starts on Monday! Newly launched products are out and we want to share! Next up are these fun socks with the Database Health Monitor logo pattern. Simply RETWEET the “official” giveaway post and tune Sept 16th to see the winner. Must follow us on Twitter to win. Good Luck! Limit 1 win per person per 30 days. Must …

New Giveaway Starting Soon Read more »

By Posted on Posted in Database Health No Comments Tagged with

The August 2022 version release of Database Health Monitor isn’t a major release although it does includes bug fixes and feature enhancements. Bug Fixes On the Disk space (instance) report the free space and total space column headings were reversed and the space was indicated in GB, but actually the numbers were shown in MB. Both have been fixed. Fixed …

August Database Health Monitor Version Release Read more »