Sample Header Ad - 728x90

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