Details - Instances

The Instances - Details screen consists of 3 sections, Overview, Properties, and Volume Metrics Statistics, with each section displaying multiple cards with data related to the selected Instance. When entering the Instances - Details screen, a single Instance must be selected from the drop-down filter before information will display. The Environment filter may be used to reduce the options available in the Instances drop-down. Selected filters will persist between the Overview and Details Screen, however, if more than one Instance was chosen on the Overview filter, the Instance filter will be reset for the Details screen.

The Date Picker in the upper right corner of the screen allows the selection of a date up to the current date. The data displayed in the Instances - Details screen will be based on the date chosen. The data will be an aggregation of the 7 days prior to the date chosen, with the date chosen not being included in the aggregation.

Overview

Displays the Instance-specific information as defined by the filter selected.

Instance Availability

Displays the availability percentage per day as a bar chart for the previous seven (7) days from the selected date. Availability is determined by the ability of the WISdom collection service to successfully connect to the selected Instance during its normal collection.

• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.

Alert Status

Displays information on the status of alerts defined by either the Open or Closed status and divided between P0/1 or P2 alerts.

• For more information, see the Alerts section of this manual.

Silencing Window

Displays the scheduled Start and End times for any Silencing windows defined for the Instance.

• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.

Database Space Allocation

Displays information about the Total Allocated Space, including both Data and Transaction Log file Space, for the selected Instance. This information includes the total Allocated Space as the number in the gauge chart, then the Allocated (Reserved) Space, Percentage of Free space, and Percentage of Used Space for both the data and log file(s).

• The color-coded gauge chart compares the distribution of reserved space by percentage for both the Data and Log files. The outer ring represents the total available data space reserved while the coloring displays the percentage used. The inner ring shows the same information for the TLOG Space Reserved.
• Hover the pointer over a colored line in the gauge chart to display the Used Percentage in the center of the gauge.
• Click on the Reserve Space (either Data or TLOG) to display a pop-up that lists the Total and Free space by Database.

Properties

Displays the specifics of the setup and configuration of the selected Instance.

Resources

Displays the configured number of Processors, the Used Memory Buffer (Total Buffer Pool Used), the Total Databases (number of databases on the Instance), and Database Size (allocated space for both data and TLog files).

Database Platform

Provides the specifics of the installed SQL Instance and configured monitoring information from WISdom including properties for Product Version, Edition, Monitoring (assigned monitoring pool in WISdom), Environment (assigned in WISdom configuration), Virtual Name (if applicable), Port Number, and Patch Level.

• To sort the data, click on the column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.

Installed Components

Displays any installed components by Component Name (SQL Reporting Services, SQL Integration Services, …)

• To sort the data, click on the column header.
  ### Trace Flags
  Lists all the server level Trace Flags that are enabled.
• Click the [?] icon in the row to display a description of the Trace Flag, including notes and scope.

Instance Configuration

Displays a subset of the sys.configurations along with the value currently set (this data is updated daily).

• To sort the data, click on the column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.

Volume Metric Statistics (Currently labeled Overview )

Displays details of the performance status of the selected Instance.

Top Statements

Displays the top SQL statements a sortable table format by the descending percentage of Reads (default) for the selected Instance. To sort the data, click on the column header.

• The Reads column displays
• The CPU column displays
• The Duration column indicates
• The Executions column indicates
• The Database column indicates
• The Object column indicates
• The SQL Statement column displays

To display the full SQL Statement in a flyout, click on the partial statement in the SQL Statement column. To Copy the full statement, click the Clip-Board Icon in the upper right corner of the flyout.

• To display more rows in the table, click on Rows per page and select a number. The default is five (5) rows.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.

Instance Performance Stats

Displays a table listing the Databases hosted on the Instance with corresponding statistics for Database Size, Memory Usage, Percentage IO, Percentage CPU, and Percentage Memory.

• To sort the data, click on the column header.
• By default, the number of rows displayed in the table is 25. To change the number of rows displayed, click the Rows per page and select a number.
• The percentage columns highlight the column value in the row corresponding to the value of the percentage.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.

Batch Response Stats

Displays a table that lists the details of Batches sent to the SQL Instance. The table displays the Batch information in blocks of time:

• 0-10ms, 10-100ms, 100-500ms, 500ms-1sec, 1-5sec, 5-50sec, 50-100sec, and more than 100sec.
• The columns of data include, percentage Requests, CPU Time: Requests (in CPU Cycles), percentage Total CPU, and CPU Time: Total (ms).
  To sort the data, click on the column header.
• The CPU Time: Requests and CPU Time: Total (ms) columns are highlighted to indicate the percentage of the column total that the value represents.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The new display can be sorted by clicking on a column header.