The database health check screen runs performance and configuration diagnostic tests against a database and gives warnings & recommendations based on what it finds.
Results are either "Warning" - action should be taken to remedy the problem; "Info Only" - a definite course of action cannot be given but user experimentation should be performed or "Ok" - the test passed.
Clicking on a warning in the grid will display and related details in the textbox at the bottom of the screen. These may include information like table and files effected by the health check and amounts such as disk sizes of over thresholds.
The diagnostics include T-SQL checks to identify code that may need altering to avoid common performance pitfalls as well as database configuration issues.