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
| Button | Window |
|---|---|
| Live | The last hour, one point a minute. The page refreshes every minute. |
| 1D, 1W, 1M | The last 24 hours, 7 days or 31 days, in hourly, 4-hour or daily bars. |
| Calendar button | Up 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
Select a Preset: Overview (the default), CPU, Memory, Throughput, I/O, Locks & Waits or Tempdb.
To change one chart, click its title and select a metric. To find a metric, type a part of its name.
To keep the six charts for your next visit, click Save Preset. Scops keeps them in this browser.
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:
| Metric | Amber from | Red from |
|---|---|---|
| SQL Server CPU, Other processes CPU | 80% | 90% |
| Tempdb used | 80% | 90% |
| Read latency, Write latency, and the latencies of one database | 20 ms | 50 ms |
| Memory grants pending | 1 | 5 |
| On the chart | Meaning |
|---|---|
| A line with a shade under it | The usual value at this time of the day, learned from the last 28 days. The readout shows it as Usual. |
| A gap | Scops did not read the instance then. A gap is not zero. |
| Not read on this server | The instance does not give this value. The reason shows under it. |
The charts of one database have no usual value.
Related
Updated November 22, 2026