Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

VERSIONI DI PROVA GRATUITA

Gaps in the workload on SQL Server overview page (4375056)

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

Gaps in the workload on SQL Server overview page
Descrizione

When viewing the workload trend in the SQL Server overview page there are gaps in the workload. These are not shown in the larger drilldown chart in the popup or in SQL PI.

Drilling down into the chart looks like this

and SQL PI looks like this
Causa

This is caused by the increment of the charts displaying the values.
Risoluzione

This is because the chart is based on an average five minute increment. Drilling down further and you can see the zero workload

Similarly, looking in PI shows no gaps because of the five minute increments, however when you drill down closer you can see there was no activity

The user can view the raw data by exporting the chart to Excel

Users can also turn on the monitoring of the background processes activity which is normally filtered out by PI to focus on the user processes in Knowledgebase article 4228308 or review the host metrics at a time where there is more activity.

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Request a KB Article

Leave a Comment

Contenuti consigliati

Prodotto/i:: Foglight Cloud
Hosted; Foglight
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5; Foglight Evolve
7.1.0, 6.3.0, 6.1.0, 6.0.0, 9.3, 9.2, 9.1, 9.0; Foglight for Databases
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Argomento/i:: Troubleshooting

Cronologia articoli:: Data di creazione: 3/7/2024
Ultimo aggiornamento: 3/7/2024

Cerca in tutti gli articoli