Tempdb Usage SQL statement is not the same as Sessions SQL statement for the same SPID. (4220655)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Tempdb Usage SQL statement is not the same as Sessions SQL statement for the same SPID.
Beschreibung

Tempdb Usage SQL statement is not the same as Sessions SQL statement for the same SPID.
Lösung

This is as expected since each screen has its own data collection. By default when application is closed each collection runs every 5 minutes. Within 5 minutes there may be lots of SQL has executed in same session, hence, different SQL Statements shown.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Spotlight on SQL Server Enterprise
12.2, 12.1, 12.0.1, 12.0

Titel