Timeclock Form Lagging

Problem

When the Timeclock form is opened it lags and Crows Nest stops responding.

Solution

1. From your Crows Nest server, launch Microsoft SQL Server Management Studio (SSMS).
   

   

2. Expand the Databases folder, right-click the CrowsNest database and choose New Query.
   

   

3. Copy & paste the query below into the new query.

   exec sp_updatestats

   

4. Click ‘Execute’.
   

   

5. After a few moments, you should see ‘Query executed successfully' at the bottom of your
   SSMS window.
   

   

6. Right-Mouse-Click CrowsNest database and select ‘Properties’ from the context menu.
   

   

   
   

7. Select the ‘Options’ tool from ‘Select a page’ and ensure ‘Auto Create Statistics’ and
   'Auto Update Statistics' are both set to ‘True’.