SQL Server Metrics

Use Metrics to read the performance counters of one SQL Server instance, six charts at a time, live or over a month.

Before you begin

  • You need the View SQL Server and View Metrics permissions.
  • Scops reads the metrics of the instance every minute and keeps them for 31 days by default (see Retention).

Choose the window

ButtonWindow
LiveThe last hour, one point a minute. The page refreshes every minute.
1D, 1W, 1MThe last 24 hours, 7 days or 31 days, in hourly, 4-hour or daily bars.
Calendar buttonUp to 31 days. Select From and to, then click Apply.

A window longer than 4 hours shows bars. To open one bar as the window, click an hourly, 4-hour or daily bar. The line at the top left shows the window and the size of its points or bars. All times use the clock of the instance.

Pick the metrics

  1. Select a Preset: Overview (the default), CPU, Memory, Throughput, I/O, Locks & Waits or Tempdb.

  2. To change one chart, click its title and select a metric. To find a metric, type a part of its name.

  3. To keep the six charts for your next visit, click Save Preset. Scops keeps them in this browser.

  4. To go back to the charts that Scops gives the preset, click the reset button next to the presets.

When you show one database, the Database preset comes first: the file I/O of that database. The other presets show the instance, and the word instance marks them.

Read a chart

Under its title, each chart says what the value is and which way is bad. NOW is the newest point. AVG, MAX and MIN are for the window. NOW and MAX have a color only when they cross a line:

MetricAmber fromRed from
SQL Server CPU, Other processes CPU80%90%
Tempdb used80%90%
Read latency, Write latency, and the latencies of one database20 ms50 ms
Memory grants pending15
On the chartMeaning
A line with a shade under itThe usual value at this time of the day, learned from the last 28 days. The readout shows it as Usual.
A gapScops did not read the instance then. A gap is not zero.
Not read on this serverThe instance does not give this value. The reason shows under it.

The charts of one database have no usual value.

Updated November 22, 2026