This query is executing multiple times using different values as params. It executes after new object is saved. In total it takes a few seconds to complete.
What is the query for? Is there a way to defer them?
-- Executed against JFBTSNPM12SQL55.colo.brandideas.com
USE [merlin_20170615]
DECLARE @p0 Int SET @p0 = 12
DECLARE @p1 NVarChar(4000) SET @p1 = '[Int32]''1'''
-- Executed query
select top 1 N0."Oid",N1."TargetType",N1."TargetKey",N1."OptimisticLockField",N1."GCRecord",N1."ObjectType",N0."GuidId",N0."IntId",N0."DisplayName" from ("dbo"."AuditedObjectWeakReference" N0
inner join "dbo"."XPWeakReference" N1 on (N0."Oid" = N1."Oid"))
where (N1."GCRecord" is null and (N1."TargetType" = @p0) and (N1."TargetKey" = @p1))