Blocking in SQL Server can occur when….. one query is holding a lock on a particular resource, such as a table or row, and another query is attempting to acquire a conflicting lock on the same resource. This can cause the second query to wait until the first query releases its lock, which can lead to performance issues and, in …

Blocking in SQL Server 101 Read more »

With over 2000 downloads since the last updated to Database Health Monitor, I figured it was time to get another release of the product out. New Features in 2.6 Added a Job Schedule instance level report. Added an option on the statistics report to show statistics for all databases, and to generate the script to rebuild statistics for all databases. …

Database Health Monitor October 2017 Version Released Today Read more »