Troubleshoot slow performance with high SQL CPU utilization

Scenario

Practice CS may encounter slow performance and show high SQL Servers CPU Utilization when there are a large number of files in the
WinCSI\Practice CS Data\Data\Integration\ClientStatusEvent
folder.

Cause

This folder is where all Client Status event integrations files are pushed from UltraTax CS in order to complete Projects and Tasks within Practice CS. Practice CS runs a background process when the application is open on the network to import and clear these events.
If staff don't have full read, write, edit rights to the
WinCSI\Practice CS Data
folder these files won’t be able to be cleared causing a backlog of files to process.

Solution

Give all users full rights to the
WinCSI\Practice CS Data
folder and all subfolders.