Non Buffer Latch - Forefront Identity Manager
2
votes
1
answer
221
views
We are using Forefront Identity Manger and we are doing an initial load to which we are experiencing slow performance.
I always start with wait types for such things and can see
%30 CXPACKET, %25 LATCH_EX and %15 ASYNC_NETWORK_IO.
I understand that LATCH_EX
is a non buffer wait type so I looked in sys.dm_os_latch_stats
and can see that %87 of the latch waits is down to ACCESS_METHODS_DATASET_PARENT
.
Is this a problem? Even on Paul Randals blog I am unclear what my issue is if at all.
Thanks
Asked by Tom
(1569 rep)
Aug 14, 2015, 03:04 PM
Last activity: Aug 14, 2015, 04:12 PM
Last activity: Aug 14, 2015, 04:12 PM