Versions Compared

Key

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

...

Tier. Each row corresponds to an instance. The All row displays the average availability (%) of all instances. The following table shows the information displayed in the Instance table.

Table 4- 1 Instance table

ColumnDescription
IconIndicates whether or not the instance is available.
InstanceName of the instance.
In MS-SQLBreakdown of In MS-SQL duration of the instance.
ExecutionsTotal statements executions.
AvailabilityAverage percentage of time the instance was available.

Anchor
AbouttheInstancedetailsareaintheDashboardtab
AbouttheInstancedetailsareaintheDashboardtab
About the Instance Details area in the Dashboard tab

...

The following table describes the information displayed in the Instance Details area.

Table 4- 2 Information displayed in the Instance Details area

TabInformation Displayed
OverviewThe Overview tab displays In MS-SQL data and performance findings for the selected instance.
ApplicationsThe Applications tab displays the top resource-consuming databases, programs and machines.
More

The following options are available in the More tab:

  • The Statistics tab displays statistical information for the selected instance, as reported by the SQL Server and collected by the Precise for SQL Server Collector.
  • The Activities tab displays the top resource-consuming statements, logical files and storage devices.
  • The Availability tab displays the average percentage of time the instance was available, and a detailed log of the changes in availability status.
  • The Current tab displays the overall activity and active sessions that occurred within the last minute for the selected instance.
Info

The Current tab is not available if All Instances is selected.

Info

If you select the All row, the information displayed reflects the average availability of all instances. The "Current" option and the Findings table will not be available.

...

The following table describes the information displayed in the Overview tab.

Table 4- 3 General instance data

General Instance DataDescription
In MS-SQLDisplays a breakdown of the total In MS-SQL duration over time, into states such as, Using CPU, I/O wait, and Lock Wait.
FindingsLists all the statements, collapsed statements, tables or instance events that were detected for a specific instance. All problems are ranked by severity. The information displayed in the findings table is also displayed in the SmarTune tab.
Details for ... FindingProvides quick links to additional tabs and views that would be helpful in your analysis of a particular problem.

About observing top resource-consuming entities

...

The following table describes the information displayed in the Databases table.

Table 4- 4 Database applications

ColumnDescription
DatabaseThe name of the top resource-consuming databases.
SessionsTotal number of sessions opened.
In MS-SQL

The resource consumption of the database broken down into states such as, Using CPU, I/O wait, Lock wait states.

Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.

The following table describes the information displayed in the Programs table.

Table 4- 5 Program applications

ColumnDescription
ProgramThe name of the top resource-consuming programs.
SessionsTotal number of sessions opened.
In MS-SQL

The resource consumption of the program broken down into states such as, Using CPU, I/O wait, Lock wait states.

Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.

The following table describes the information displayed in the Machines table.

Table 4- 6 Machine applications

ColumnDescription
MachineThe name of the top resource-consuming machines.
SessionsTotal number of sessions opened.
In MS-SQL

The resource consumption of the machine broken down into states such as, Using CPU, I/O wait, Lock wait states.

Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.

About examining statistics for an instance

...

All items in this display launch the Statistics tab with an Instance or Precise for SQL Server Tier context. The following table describes the information displayed in the Statistics tab.

Table 4- 7 Instance statistical data

Instance Statistical DataDescription
Server CPUDisplays the SQL Server instance CPU utilization for the selected instance with respect to the CPU utilization of other processes (non-SQL Server).
LoadDisplays instance load, for the selected instance, broken down into batch requests/sec, transactions/sec, and logins/sec.
Page FaultsDisplays memory paging of the selected instance vs. memory paging caused by other processes (non-SQL Server).

About viewing top resource-consuming statements, logical files and storage devices

...

All entities in this display launch the Activity tab, in context of an instance or Tier. The following table describes the information displayed in the Statements table.

Table 4- 8 Statement activities

ColumnDescription
StatementDisplays the ID of the top resource-consuming statements.
Duration (Avg)Displays the average duration of the statement.
In MS-SQL

Displays the resource consumption of the statement broken down into states such as, Using CPU, I/O wait, and Lock wait states.

Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.

The following table describes the information displayed in the Logical Files table.

Table 4- 9 Logical files activities

ColumnDescription
DatabaseDisplays the name of the file's database.
Logical FileDisplays the logical name of the file.
I/O Wait

Displays the total I/O waits registered for the file.

Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.

The following table describes the information displayed in the Storage Devices table.

Info

This information is only displayed if storage points are installed.

Table 4- 10 Storage device activities

ColumnDescription
Device TypeIndicates a type of storage device, such as, Windows, HP, Symmetrix.
Unit IDDisplays the ID of the device's unit.
DeviceDisplays the name of the device.
I/O Wait

Displays the total I/O waits registered for the device.

Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.

About viewing the availability of SQL Server instances

...

The following table describes the information displayed on instance availability.

Table 4- 11 Instance availability

ItemDescription
AvailabilityThe average percentage of time the SQL Server instance was available.
LogA detailed log of the changes in availability status.

About viewing your system's current activity

...

The following table describes the information displayed in the Session Activities area.

Table 4- 12 Sessions

ItemDescription
SessionsTotal number of sessions connected to the selected instance.
Active sessionsTotal number of sessions currently active.
Locked sessionsTotal number of locked sessions.

The following table displays information on the active sessions that occurred within the last minute, for the selected instance.

Table 4- 13 Active sessions (last minute)

ColumnDescription
IconRepresents the current session's state (such as, Lock Wait, Request Wait).
SPIDThe session ID.
ProgramThe name of the program that opened the session.
StateThe current state of the session.
In MS-SQLTotal In MS-SQL entities for the session, occurring within the last minute, broken down into states (such as, Using CPU, I/O wait, and Lock Wait).

The following table describes the information displayed in the Current Activity graphs.A

Table 4- 14 Current activity graphs

ItemDescription
Overall activity (Last minute)Provides a graphical display of the overall activity that occurred within the last minute, for the selected instance, broken down into the following states: Idle Wait, Parallel Exchange Wait, Request Wait and In MS-SQL.
In MS-SQL (Last minute)Provides a graphical display of In MS-SQL activity that occurred within the last minute, for the selected instance, broken down into states, such as, Using CPU, I/O wait, and Lock Wait.

About the Findings area in the Dashboard tab

...

  1. In the Time Frame list, choose the period of time you want to analyze.
  2. In the All SQL Server Instances table, check the current availability state of the instance you want to analyze. A status icon, located in the first column, shows the current availability of the instance. Move the pointer over the icon to display a ToolTip showing the current status of the instance and the date its status changed.
  3. Select the row of the instance you want to analyze. The average availability of the instance is displayed in the Availability column.
  4. In the Instance Details area, click More... and select Availability. Check the Availability graph to view the availability of the selected instance with respect to the configured SLA and the log. See “How Precise for SQL Server monitors availability” on page 38.

 

Precise. Performance intelligence from click to storage. Learn more > >

...