Day 9 – I/O By Drive
The I/0 By drive report gives you an overview of how much I/O each drive holding database or log files is using. Here is an example showing the IO by drive for a SQL server with no databases on the …
The I/0 By drive report gives you an overview of how much I/O each drive holding database or log files is using. Here is an example showing the IO by drive for a SQL server with no databases on the …
Here listed is the current percentages of SQL server versions running our Daily Check up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie …
SQL Daily Monitoring – SQL Server Versions for March Read more »
The I/O By Database report is one of the instance level reports available in Database Health Monitor. The I/O by database page shows the databases with the most IO on your system. This can be used to track down performance …
The waits by type for instance page shows you the most commonly occurring waits on your SQL Server. Grid Columns Row: Just the row number in the grid. Type: The name of this wait type. Wait Seconds: The total amount …
This report originally came from a customer request. They wanted to be able to export a list of all SQL Servers to another tool for managing all their SQL Server licenses. You can get to this report by going to …
The Blocking by Hour of the Day report is one of the instance level reports available in Database Health Monitor. Important Note: The blocking percentages are relative for the date range shown. We find the hour that has the most …
The SQL CPU by Hour of Day report lets you see what the average CPU load was per hour for the last week and beyond. I have used this report countless times to explain to customers what is going on …
This report is commonly used to check in on the status of data files and log files for SQL Server. It is much quicker than right clicking on each database in SSMS and browsing to view the files. Some of …
10 Days of Reports with Database Health Monitor Day 2 – Table Size The Table Size report shows you the tables that are using the most disk space in your database. Many times, I’ve discovered a table in a SQL …
10 Days of Reports with Database Health Monitor Day 1 – Database by Size The databases by size report is a quick and easy way to see which databases on your SQL Server are the largest. The chart shows the …