Database server

This table describes the various panels of the Database Server report:

Panel Description
Database Server Provides machine name, server name, SQL server edition details, SQL server login name, user rights, operating system, processor details, the database name, and the server type like physical or virtual server. This panel also provides Hard disk space utilization details, memory details, server uptime, last rebooted time, database size utilization, temp DB utilization size, SQL server services memory utilization, and the count of the current processes running on the database.
Note: If the install drive space size exceeds the threshold value, a warning message is displayed on the panel.
TempDB Utilization Provides the total size of the TempDB and the size utilized.
Database Current Processes Provides the count of processes that are running, sleeping and waiting.
SQL Server Services Memory Utilization Provides the capacity of the SQL server and the SQL server agent(in MB).
System Configuration Provides details the settings available on the machine, the recommended and the current settings for each available settings and the status of the settings.
Backup Details Provides the days since the last backup was triggered and the last back up date.
Other Information Provides date and time of the last statistics and rebuild activity and also the unused partition count.
Queries by longest CPU time Provides the query details, the longest CPU time utilized to run queries, the percentage of the CPU time already utilized, and the percentage of the CPU time waiting.
Queries longest time being blocked Provides the query details, the total time blocked by the CPU to run queries, the percentage of the CPU time already utilized, and the percentage of the CPU time waiting.
Queries with most I/O Provides the query details and the total I/O.
SQL Server Recent Logs Provides the date and time of the log raised, the process for which the log is raised and the log message displayed.
Disk Usage by Top 10 Tables Provides a list of the top 10 table names and the disk usage size of each table.
Database Space Utilization by Product Provides the database size utilized by the installed products.
Disk Usage by Top 10 Analysis for Authorizations Insight Provides a list of the top 10 analysis names and id and the disk usage size by each analysis.
Analysis Storage Threshold Limit Insight Category Displays the Insight specific analysis threshold value limit and the actual count of analysis displayed.
Database size growth statistics (Last 10 days) Provides the used space size and the available space size of the database and the date and time it was last used.
Tempdb size growth statistics (Last 10 days) Provides the used space size and the available space size of the Tempdb and the date and time it was last used.
Fuzzy Rule Evaluation Provides details of the Fuzzy rule names that has been evaluated and stored in database
Tables with Indents > 1 billion Provides names of the tables with Indents greater than one billion.
Failed What-if and requests Provides a count of the failed What-ifs and requests.

The following system tables have been used in the System Health Utility.

  • sys.databases
  • sys.configurations
  • sys.database_files
  • sys.dm_db_partition_stats
  • sys.internal_tables
  • sys.dm_db_index_physical_stats
  • sys.dm_os_sys_memory
  • sys.dm_os_sys_info
  • sys.dm_os_sys_memory
  • sys.dm_exec_query_stats
  • sys.dm_exec_sql_text
  • sys.dm_exec_query_plan
  • sys.dm_exec_connections
  • sys.dm_exec_requests
  • sys.dm_os_waiting_tasks
  • sys.dm_exec_sessions
  • sys.dm_db_file_space_usage
  • sys.dm_os_performance_counters
  • sys.indexes
  • sys.objects