The query below is running all the time. Does this need to run so much? (@p1 varbinary(16),@p2 varbinary(16),@START_ROW_NUMBER int,@END_ROW_NUMBER int) SELECT * FROM ( SELECT resource_name, resource_tag, serial_number, host_name, mac_address, dns_name, ROW_NUMBER() OVER(ORDER BY audit_trail_date) ROW_NUMBER__ FROM aud_ca_owned_resource WHERE own_resource_uuid = @p1 AND asset_source_uuid = @p2 ) SUBQUERY_ALIAS__ WHERE ROW_NUMBER__ BETWEEN @START_ROW_NUMBER AND @END_ROW_NUMBER
This query is being called and executed by registration service. It is continuously checking if any of the assets are modified/added/deleted and accordingly calling CORA to register/ReRegister/Deregister assets from CORA.