Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Blocked Sessions

Displays blocked process sessions session information on the SQL Server instance.  

...

Displays the percentage of CPU consumed by your SQL Server, virtual machine, and the host server.

Disk Queue Length

...

The Dashboard console has a new alert grid and custom filters that help you organize the list columns in  in your most convenient way. Click the icon located next to the column name 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

...

Refers to the total number of SQL Server user sessions.

SQL CPU Usage

Refers to the average percentage of SQL Server processor usage on the computer hosting the SQL Server instance.

SQL Memory Usage

Refers to the amount of memory in use by the monitored SQL Server instance.

...

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:

...

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.

...

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 a 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.  

...