High CPU Utilization on Inventory Central Server 16 Release 6
Anyone else experiencing high CPU utilization on most recent inventory release? My CPU is pegged at 100 on my central server. Looking at Windows event logs, I keep seeing a repeat of a warning, 60020. Same thread listed in each one. Wondering if I have a stuck scan or job of some sort.
Current database operations (time in seconds)
Assembly: C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\PDQInventoryService.exe
Version: 16.6.0.0
Process: 13784 PDQInventoryService
AppDomain: PDQInventoryService.exe
Database: C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db
Thread: 212 Method: Run | C:\AABUILD\Projects\Common 16.18\AdminArsenal.Product.Server\Reports\Engine\Basic\BasicReportDefinition~Server.cs
Statements: 8
Elapsed: 30.08
Begin Wait: 0.00
All Statements: 30.07
Average Statement: 3.76
0.00: begin
0.06: select distinct CollectionComputerId as Key, ComputerId as Value from (select cc.rowid as CollectionComputerId, cc.ComputerId, cc.CollectionId, c.* from Collections c join CollectionComputers cc using (CollectionId) where IsMember) ComputerCollectionView
0.00: select rowid from Collections ComputerCollectionView where ComputerCollectionView.Name = 'Elitebook' collate nocase
0.02: select CollectionComputerId as [_key], Name as [_value] from (select cc.rowid as CollectionComputerId, cc.ComputerId, cc.CollectionId, c.* from Collections c join CollectionComputers cc using (CollectionId) where IsMember) where CollectionComputerId in (
0.00: select rowid from Collections ComputerCollectionView where ComputerCollectionView.Name = 'ProBook' collate nocase
9.67: select rowid from Collections ComputerCollectionView where ComputerCollectionView.Name glob 'Surface'
10.94: select rowid from Collections ComputerCollectionView where ComputerCollectionView.Name glob 'Toshiba'
9.37: select rowid from Collections ComputerCollectionView where ComputerCollectionView.Name glob 'Latitude'
-
@Jason & @Curtis_Hendzell Did you guys open cases as well? Where are you in your case if so?
-
I am running same as you, but no CPU issues. Support did review my DB and provided guidance on performance improvements:
Last, if you have any collections using the "member of collection" filter, let's change that to its more reliable filter-cousin "computer collection is member" instead. Development has been able to find a performance issue that is directly related to using that particular filter.
Not totally sure why this is not a little more publicized, but sounds like a good way to improve performance. I have a ton of these in my environment that I am starting to remediate.
From Ticket #154507
One of our clever guys here wrote a SQL report to find filters which might need changing:
Select Collections.Name as "Collection", reportdefinitionfilters.Value as "Filtering for this Collection" from Collections join reportdefinitionfilters on Collections.ReportDefinitionId = reportdefinitionfilters.ReportDefinitionId where reportdefinitionfilters.tablename = 'Collection'
Please sign in to leave a comment.
Comments
16 comments