Curious anyone else using appinsight for active directory and seeing DB blocking going on, even if the application is unmanaged?
Opened a support case several days ago and I get 20 recommendations about over polling and disc space but can't seem to get any direction on the actual DB blocking....
SQL causing the issues, according to DPA:
/* (comment inserted by DPA)
Character Range: 477 to 1048
Waiting on statement:
MERGE INTO dbo.APM_ActiveDirectoryBbSubnet
as
target
USING @Subnets
as
source
ON target.Name = source.Name
AND target.SiteID = source.ID
WHEN MATCHED THEN
UPDATE
SET SiteID = source.ID WHEN NOT MATCHED BY TARGET THEN
INSERT
(
Name,
SiteID
)
VALUES
(
source.Name,
source.ID
)
WHEN NOT MATCHED BY SOURCE
AND target.ID IN
(
SELECT *
FROM @takenSubnets
)
THEN DELETE;
*/
(@applicationId int,@Subnets [dbo].[APM_ActiveDirectoryBbIDToNameType] READONLY)
DECLARE
@takenSubnets TABLE ( ID int NOT NULL );
INSERT
INTO @takenSubnets
(
ID
)
SELECT subnet.ID
FROM APM_ActiveDirectoryBbSubnet as subnet
INNER JOIN APM_ApplicationItem as appItem
ON appItem.ID = subnet.SiteID
AND appItem.ApplicationID = @applicationId
/* BEGIN ACTIVE SECTION (comment inserted by DPA) */
MERGE
INTO dbo.APM_ActiveDirectoryBbSubnet as target USING @Subnets as source
ON target.Name = source.Name
AND target.SiteID = source.ID WHEN MATCHED THEN
UPDATE
SET SiteID = source.ID WHEN NOT MATCHED BY TARGET THEN
INSERT
(
Name,
SiteID
)
VALUES
(
source.Name,
source.ID
)
WHEN NOT MATCHED BY SOURCE
AND target.ID IN
(
SELECT *
FROM @takenSubnets
)
THEN DELETE;
/* END ACTIVE SECTION (comment inserted by DPA) */
