The single instance dashboard includes an overview section for the selected monitored SQL server and specific category views. SQL Diagnostic Manager users are able to obtain details on sessions, queries, resources, and databases. Click image to view full size.

SQL Diagnostic Manager allows you to launch SQL Workload Analysis in context of your monitored SQL Server instance from both, the desktop client and the IDERA Dashboard.

You can launch SQL Workload Analysis from the single instance view and its tabs of the SQLDM web console. The icon Launch SWA located on the top-right side of the screen is available when your instance is registered in SQL Workload Analysis product.


In the single instance dashboard, you can find the following sections:

Server status

In this section view the status of your monitored SQL Server and its alerts.

Server properties  

In this section view the most important characteristics of your monitored SQL Server instance.

Instance Name 

Displays the name of the monitored SQL Server instance or its friendly name assigned in the desktop console.

Assign a friendly name to your instance that is meaningful to you and easy to identify.

SQL Version

Indicates the current SQL Server version including service pack and build information on this SQL Server instance.

SQL Edition

Indicates the current SQL Server edition, including Enterprise, Business Intelligence, or Standard, installed on this SQL Server instance.

Running since

Indicates the timestamp associated with the most recent restart of this SQL Server instance.

Clustered

Indicates whether this SQL Server instance is part of a cluster. If it is part of a cluster, SQL Diagnostic Manager displays the name of the active node.

Processors

Indicates the total number of processors associated with this SQL Server instance and how many of these processors are currently in use.

Host

Indicates the name of the server hosting this SQL Server instance.

Host OS

Indicates the current operating system on the server hosting this SQL Server instance.

Host Memory (GB)

Indicates the total amount of memory on the server hosting this SQL Server instance.

Service status

In this section view the status of the SQL Server services:

File Use

In this section view file use for your monitored SQL Server instance.

Data File(Allocated GB)

Displays the allocated data space in GB for this SQL Server instance.

Data File (Used GB)

Displays the used data space in GB for this SQL Server instance.

Log File (Allocated GB)

Indicates the allocated log space in GB on the SQL Server instance.

Log File (Used GB)

Indicates the used log space in GB on the SQL Server instance.

Database count

Indicates the number of databases contained in the monitored SQL Server.

Databases roll up view

The Databases roll up view shows the monitored databases for the selected instance. Information provided includes:

Database

Displays the database name.

Creation Date

Displays database creation date and time.

Data Size (MB)

Displays the size of all data files used in this SQL Server instance.

Log Size (MB)

Indicates the current size of the log files on this SQL Server instance.

Status

Indicates the operational status of the database such as Normal, Offline, or Suspect.

If you click any row of the Database roll up view, SQL Diagnostic Manager directs you to the databases tab of the single instance dashboard for more details.

To sort information in the Databases roll up view, click any of the column headers.

Charts

The single instance dashboard includes the following charts:


Response Time 

The Response Time chart displays the response time (in milliseconds) it takes a Select SQL statement to go to the SQL Server instance and back.  This chart indicates the current speed and congestion of the network as well as the speed with which SQL Server processes small queries.  To obtain additional key diagnostic statistics for sessions on your SQL Server instance, click the chart and you’re directed to the Sessions > Overview view.  This view contains various charts like the Response Time (ms), Session Activity, and Blocked Sessions.

SQL Server CPU Activity 

The SQL Server CPU Activity chart displays the percentage of a CPU consumed by your SQL Server, virtual machine, and host server. To obtain additional key diagnostic statistics for monitoring the resources for your SQL Server instance and computer on which it resides, click the chart and you’re directed to the Resources > CPU view.  This view contains various charts like the CPU Usage (%), Processor Time (%), and Processor Queue Length.

OS Memory Usage

The OS Memory Usage chart displays information in GB on the physical and virtual memory in use during the current day.  To obtain additional key memory statistics on the computer hosting your SQL Server instance, click the chart and you’re directed to the Resources > Memory view.  This view contains various charts like SQL Memory Usage (MB), Memory Areas (MB), and Page Life Expectancy (sec).

Disk Busy

The Disk Busy chart displays the percentage of time during the last ten minutes that the disk was not idle for all the disks (combined) on the server that the SQL Server instance resides.  To obtain additional key statistics on the way your disks are used on the computer hosting your SQL Server instance, click the chart and you’re directed to the Resources > Disk view. This view contains various charts like the Disk Reads/Second per Disk, Disk Writes/Second per Disk, and the SQL Server Physical I/O.

Category views

The single instance dashboard contains the Sessions, Queries, Query Waits, Resources, Databases, and Alerts tabs where you can see metrics and information on these category views.


From these tabs you can:

Access the single instance dashboard

SQL Diagnostic Manager provides several paths to access the single instance dashboard. The first access path is by clicking the appropriate monitored SQL Server instance in the list, thumbnail, or heatmap sub-views. The second access path is by clicking a specific instance from the Active Alerts panel, or the Most Critical Instances view in the main dashboard. It is also possible to access the single instance dashboard by clicking a specific instance or database in the Top servers by alert count, Top servers by response time, and Top databases by alerts widgets.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal