Page History
SQLDM Web Console helps you to identify and diagnose issues through two main views in the home tab:
These
The web console's main dashboard is comprised of three main sub-views:
These sub- views display all data collected at the last refresh for all your monitored SQL Server SQL Server instances. To access any sub- view, click the appropriate button in the upper-right corner left panel of the dashboard as shown in the following image.
Anchor thumbnail thumbnail
Thumbnails
| thumbnail | |
| thumbnail |
The thumbnail view is set by default in the SQLDM Web Console and provides you with a graphical replication of your monitored SQL servers. Access additional details in the single instance view by clicking on a thumbnail instance.
The thumbnail view displays basic statistics about your SQL Servers:
...
Server Name
Displays the server name. The SQLDM Web Console only displays 30 characters in the thumbnail. If the name is longer, you can see the entire name by hovering the mouse over the card.
Alerts/No Alerts
Displays the number of triggered alerts in the instance according to the state of the card. For example, if the card is critical, the Alert field shows only the number of critical alerts.
Blocked Status
Displays a BLOCKED or BLOCKING red message next to the Alert field when the server is blocking or is blocked by another.
CPU
Refers to the average percentage of SQL Server processor usage on the computer hosting the SQL Server instance.
Wait
Displays the Total Server Waits for the monitored SQL Server instance
Disk
Refers to the number of physical reads and physical writes made by the SQL Server instance between refreshes.
Mem
Refers to the percentage of allocated memory by the monitored SQL Server instance.
...
Anchor List List
| List | |
| List |
...
Lists
The list sub-List view offers a means to quickly identify the status of instances, as well as the possibility to navigate to the single instance dashboard when clicking on a specific row.
The list sub- view provides you with the following SQL Server information:
SWA
Displays the SWA icon when the instance is registered in SQL Workload Analysis.
Instance Name
Displays the name of the monitored SQL Server instance.
...
Displays the health index in percentage in a red square.
Alert
Displays the current severity number of triggered alerts in the value of the instance.
CPU, Memory, I/O, Database, Logs, and
...
Query
Displays the overall health index icon for each option.
SQL Server Version
...
Health Index
Displays the health index in percentage.
SQL Server Status
Displays the status of the SQL Server service such as running, stopped, and paused.
SQL Agent Status
Displays the status of the SQL Server Agent service such as running or stopped.
DTC Status
...
Displays the percentage of CPU consumed by your SQL Server, virtual machine, and host serverDisplays the status of the Distributed Transaction Coordinator service such as running or stopped.
Available Memory (MB)
Indicates how much available memory is allocated for SQL Server.
Blocked Sessions
Displays blocked process sessions information on the SQL Server instance.
...
.
...
Displays the average number of system requests that are waiting for disk access on the computer hosting the SQL Server instance
Actions
...
Search Instance
Type the name of the instance you are looking for.
Options
Choose the columns to display in the list view.
The Dashboard console has a new alert grid and The Web Console console has custom filters that help you organize the list columns in in your most convenient way. Click the icon located To do so, hover the mouse over the column name and the
icon appears next to the column name, click the icon to expand the drop-down menu. This menu allows you to sort your criteria by Sort Ascending or Sort Descending, you can remove or add columns, lock and unlock, and group the information by fields.
...
The thumbnail sub-view is the default view in the SQL Diagnostic Manager web console's dashboard and provides you with a graphical replication of your monitored SQL servers. Access additional details in the single instance dashboard by clicking on a thumbnail’s instance name or easily spot categories that have active alerts as marked by a critical icon. Navigate to an instance’s specific category view in case it has active alerts by clicking on the marked category icon. You can also launch the SQL Diagnostic Manager console directly from the thumbnail sub-view by clicking the SQL Diagnostic Manager icon .
The thumbnail sub-view displays basic statistics about your SQL Servers:
SQL Server version
Displays the edition and version of SQL Server software used in this instance.
Response Time
Refers to the time it takes for a query to go from the SQL Diagnostic Manager Console to the SQL Server instance and back.
User Sessions
Refers to the total number of SQL Server user sessions.
SQL CPU Usage
Refers to average percentage of SQL Server processor usage on the computer hosting the SQL Server instance.
SQL Memory Usage
Refers to amount of memory in use by the monitored SQL Server instance.
SQL Disk I/O
Refers to the number of physical reads and physical writes made by the SQL Server instance between refreshes.
In addition, the thumbnail sub-view includes CPU, Memory, I/O, and Response Time sparkline graphs for a 1 hour-view so that users can obtain an overview of key metrics quickly.
Category icons and actions
In the thumbnail sub-view, use your mouse cursor to hover on a category icon in the left of the thumbnail. If the category icon contains active alerts, you can click it to access the Alerts Detail screen.
If there are no active alerts, you can click a category icon, and you are directed to a specific category view in the single instance dashboard. The table below shows the relationship between the category icons and their corresponding views:
...
...
...
...
...
...
...
...
| Info |
|---|
Instances in thumbnail sub-view display according to severity. This means that critical instances show up on the top of the dashboard. |
...
The heatmap sub-view provides you with a visual overall status of your SQL Server environment in the form of a grid of color-coded squares that contain a health index. Through its color scheme and health index, you can easily identify which of your monitored instances need the most attention. Each square in the heatmap sub-view represents a monitored instance. From each square, you can access basic statistics but also drill down for details.
To glance at instance health information just hover over a specific square to see its health index.
Upon clicking a specific square, the health index displays performance line charts for CPU, Memory, IO, and Response Time from the past hour.
Additionally, you can:
- Click Details to access the Overview tab of the single instance dashboard.
- Launch the SQL Diagnostic Manager console by clicking the SQL Diagnostic Manager icon
.
- Launch SQL Workload Analysis by clicking the SWA icon
How to interpret the health index in the heat map sub-view?
The health index is a percentage value that provides an estimate of the relative health of your monitored SQL Server. The health index is based on the following raw calculation:
...
and create filters with selected criteria by column.
Also, you can perform other actions such as sort and search servers:
Sort
Instances on the details sub-view are sorted by severity. To re-organize information, click a column header to sort it.
Search Servers
The Search Servers bar allows you to find instances by typing the instance name you are looking for
The raw score is normalized to a range between 100% and 0%. SQL Server is healthier the closer its health index is to 100%, and it is in critical state the closer its health index is to 0%. Use the severity factors to change the relative weight in the calculation. Use tag and instance factors to assign instances more or less importance in the overall heat map ranking.
...
- Click the gear icon
- Type the values that you want in the respective Alert Scale Factor field. IDERA recommends factor values between zero and ten.
- Choose an instance from the registered instances and click Add to apply a distinctive scale factor.
- Choose a tag from the available tags and click Add to apply a distinctive scale factor.
- Click Submit.
...
.