Interested in what metrics from the database can be displayed in graphan for monitoring?
I found in the Kryon view sys.databases database in which there are fields with online, i.e. this is the real status of the database, which will change when
Also interested in the number of connections to the database at the moment?
How much memory does the database need?
So far, I am just pulling out the following options on a dashboard: [Kryon]. [Dbo]. [LeoScriptsLibraries]
[Kryon]. [Dbo]. [View_AutomationClients]
FROM [Kryon]. [Dbo]. [LeoUsers] INNER JOIN [Kryon]. [Dbo]. [LeoUserRoles]
ON LeoUsers.UserID = LeoUserRoles.UserID
But this table is not informative with 0 and 1.
SELECT Count (UserName) as 'count_users'
FROM [Kryon]. [Dbo]. [LeoUsers]