using hubble getting 150ms on swql "LicenseName"

Question

My web console is extremely slow.

ewk.jr · Answer

here's some of the info from Hubble:

142.73 Web SWQL 
SELECT l.LicenseName, la.ProductName 
FROM Orion.Licensing.LicenseAssignments la 
LEFT JOIN Orion.Licensing.Licenses 1 ON 1.LicenseKey = la.LicenseKey AND
l. a la.LicenseVersion AND 1.ProductName = la.ProductName RETURN XML RAW

140.08 Web SWQL 
SELECT LicenseName 
, LicenseType 
, LicenseKey 
, ToUtc(LicenseExpiresOn) as LicenseExpiration 
, Toutc(MaintenanceExpiresOn) as MaintenanceExpiration 
, ProductNatne
, IsHidden
, IsSubscription 
FROM Orion.Licensing.Licenses RETURN XML RAW

83.30 Web SWQL 
SELECT EntityName, Name, DisplayName, Type 
FROM Metadata.Property
WHERE is Injected = 0 AND GroupBy = 1 RETURN XML RAW

58.81 Web BL 
CoreBusinesslayerModule/GetModuleLicenseinformation

43.06 Web SWQL 
SELECT T.SourceType, T.TargetType, T.SourcePropertyName, 
ISHULL(E.OisplayName,E.Name) AS EntityDisplayName 
FROM Metadata.Relationship T INNER JOIN Metadata.Entity EON (T.TargetType = E.Type) WHERE T.TargetCardinalityMax IN ('0', '1') AND T.SourcePropertyName <> 
'CustOIIProperties' AND T.Isinjected=0 RETURN XML RAW

31.45 Web SWQL 
Select COUNT(EngineID) AS cnt From Orion.Engines (nolock = true) RETURN XML RAW

ewk.jr · Answer

i would love to, but i cant for this network.

donrobert5 · Answer

Try gathering logs and then submit it via Orion Insights.  It should give you an idea how to optimize your SW environment.

support.solarwinds.com/.../How-to-gather-and-send-a-diagnostics-file-to-SolarWinds-Support