I'm trying to track down an issue where a server will become extremely slow. But the resources all seem normal. No high CPU, Memory or Network usage. The only clue I've been able to find is on the WVDCheckpoints table. When a server becomes slow the logins are taking 90k+ ms versus the normal less than 10k ms.

I'd like to be able to see all the logins or entries for on server to see when they started. Is it possible to do that or should l be looking at a different table? I'd also like to set up an alert for when a login is taking 90k+ ms.
I see these fields available on that table but I haven't figured out how to connect it to a server. Is there a reference on how the tables are interconnected?
ActivityType
CorrelationId
Name
Parameters
_ResourceId
Source
SourceSystem
_SubscriptionId
TenantId
TimeGenerated
Type
UserName
