Membership dues Batches List Causing Performance Issues
The membership dues batches list has an inefficient recursive CTE. This is causing the list to run slowly and creating contention for tempDB. During many times where BSA was experiencing performance issues, many instances of this list were running. Furthermore, the list runs slowly often.
Steps To Duplicate
1) Add thousands of membership dues batches 2) Go to the membership dues batches list and notice it takes a long time to load, particularly if other users are also going to the batches list.
Answer:
Download and install the latest service pack which contains all fixes from previous service packs.