Here is a brief explanation of the Serializable isolation level. “A serial execution is one in which each SQL-transaction executes to completion before the next SQL-transaction begins.” You can see how that would slow things down. If a transaction that …
If the Quick Scan Report is reporting that you have Slow IO on your Log File, this can be an indication that transactions are taking a long time to complete. If you are watching your wait stats, if you log file …
Obsolete TORN_PAGE_DETECTION: There are 3 options since SQL Server 2005 for page verification. These options are used when pages are being read from or written to disk to confirm that what is in the page is a match to what was intended to …
Quick Scan Report – Using obsolete TORN_PAGE_DETECTION Read more »
The following is a list of the requested features for Database Health version 2.0. Requested Features, but not yet implemented Would be nice to have a Back button to return to the tree where you were before clicking on something. …
SQL Server SOS_SCHEDULER_YIELD Wait Type The SOS_SCHEDULER_YIELD wait is logged in SQL server when a thread doing processing voluntarily yields its processing to let another thread perofrom work.
This report shows currently running queries. This includes queries that are currently waiting, blocked or actively running.
The Quick Scan Report checks all your databases to see if they have backups or not. All those databases with no recent backups will be listed in the Quick Scan Report. Discover the risks of not backing up your SQL …
When setting up historic monitoring, Database Health Reports uses a database called DBHealthHistory on the SQL Server that you specify as the monitoring server. Step 1 is to establish a connection to the server that will hold the monitoring database. …
Release Notes outline the changes that have been made to the Database Health application since the last version. October 2024 Release – Version 1074 Release Notes Bug Fixes New Features September 2024 Release– Version 1072 Release Notes Bug Fixes September …
Database Health Monitor FAQ Pricing Testimonials Download Buy Are you a raving fan of Database Health Reports? Please add a comment below. Raves on this page generally speed up the development team. Give Database Health a try – Connect to …