0 Replies Latest reply on Dec 17, 2014 3:32 PM by designerfx

    Why are IPAM queries so expensive?

    designerfx

      I'm looking at the SQL database via appinsight and the number one most expensive query I see is for IPAM, which also seems to be the slowest responding part of our Orion install. Am I missing something? This is by and large the most significant query from Orion by far.

       

      Top 10 Expensive Queries by CPU Time (16609 ms)

       

      SET TRANSACTION ISOLATION LEVEL READ COMMITTED; WITH [Results] AS ( SELECT [T1].[DNSServer] AS C1, N'/Orion/IPAM/Dhcp.Management.aspx?tab=dnsservers&nodeid=' + CONVERT(nvarchar(max),[T1].[NodeId]) AS C2, [T1].[DNSZone] AS C3, N'/Orion/IPAM/Dns.Records.aspx?ObjectId=' + CONVERT(nvarchar(max),[T1].[DnsZoneGroupId]) AS C4, [T1].[ClientHostName] AS C5, N'/Orion/IPAM/res/images/sw/icon.DNS.ClientHName.png' AS C6, [T1].[ForwardZoneIPAddressN] AS C7, N'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=IPAMN:' + CONVERT(nvarchar(max),[T1].[ForwardIPNodeID]) AS C8, [T1].[ReverseZoneIPAddressN] AS C9, N'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=IPAMN:' + CONVERT(nvarchar(max),[T1].[ReverseIPNodeID]) AS C10, [T1].[ForwardZoneIPAddress] AS C11, [T1].[ReverseZoneIPAddress] AS C12, [T1].[DNSServer] AS [Sort0] FROM dbo.IPAM_DNSMismatch AS T1) SELECT * FROM ( SELECT [Results].*, ROW_NUMBER() OVER(ORDER BY [Results].[Sort0] ASC) AS RowNum, COUNT(*) OVER() AS TotalRows FROM [Results] ) AS NumberedResults WHERE [RowNum] BETWEEN 1 AND 6

       

      I find that searching in IPAM runs excessively slow, so is this uniquely a problem for my install or is this by design? We do have a large network.