Requires Spotlight Cloud Professional

How to open the Workload Analyzer drilldown

  1. Direct your web browser to http://www.spotlightcloud.io. Sign in an click the Monitoring tab. See also Welcome to Spotlight Cloud Monitoring.
  2. Select a SQL Server connection. Select the Workload Analyzer drilldown.

Open the Workload Analyzer drilldown for a SQL Server connection

About the workload Analyzer drilldown

Select a resource and dimension of the SQL Server instance. By default the workload resource is selected. The default dimension selected is the SQL Server instance itself.

The statistics are specific to the selected resource and dimension. The selected dimension may also impact the visual display.

About the Workload Analyzer drilldown

Resource Selector

Select a resource currently experiencing workload to drilldown on. (Resources experiencing 0 workload cannot be selected). By default, Workload is selected.

Resource Selector panel

  • Workload
  • CPU - This resource measures the rate of CPU time needed to parse, compile, and execute each statement in the query. Select this resource to inquire into any strain the SQL Server instance is putting upon the CPU.
  • I/O
  • Memory
  • Network
  • Lock
  • Latch
  • Log
  • CLR
  • Remote Provider
  • XTP
  • Other

Configure Click in the top right corner to configure the Resource Selector panel.

Dimensions

By default the entire SQL Server instance is selected. Optionally, select a dimension of the SQL Server instance to drilldown on.

The dimensions are:

  • SQL Statements
  • TSQL Batches
  • Databases
  • Programs
  • Users
  • Client Machines
  • Context Infos
  • Command Types

When the SQL Server instance is the selected dimension

Properties

The Properties panel displays properties of the SQL Server instance.

Active Time Change

Active Time Change

The name of the panel changes with the selected resource.

Network

Resource Breakdown

Show a breakdown of the use of resources over time. Hover the mouse over the chart to see the legend.

Resource Breakdown

Maximize Click in the top right corner of the panel to show the enlarged Resource Breakdown panel.

Worload Analyzer

Metric Viewers and KPI Metrics

For the selected resource and dimension, in the two Metric Viewer panels, plot any two metrics for each period over time. The KPI Metrics panel shows the last period result for each metric.

Metric Viewers and KPI Metrics

The metrics are as follows:

  • Active Time
  • Executions
  • CPU Usage
  • CPU Wait
  • I/O Wait
  • Latch Wait
  • Lock Wait
  • Log Wait
  • Memory Wait
  • Network Wait
  • Other Wait
  • Remote Provider Wait
  • XTP Wait
  • CLR Wait

Maximize Click in the top right corner of any of the metric panels to show the Key Performance Indicators panel.

Worload Analyzer

Blocked Sessions

A plot of blocked sessions over time for the SQL Server instance.

When a category is the selected dimension

Worload Analyzer

Sort the selected category by:

  • Percent of Total
  • Active Time
  • CPU Wait
  • CPU Usage
  • I/O Wait
  • Memory Wait
  • Network Wait
  • Lock Wait
  • Latch Wait
  • Log Write
  • CLR Wait
  • Remote Provider Wait
  • XTP Wait
  • Other Wait
  • Executions
  • Physical Reads
  • Logical Reads
  • Writes
  • Elapsed Time
  • Average SQL Response Time
  • Granted Memory