Database Lagging and Timing Out

Owned by Mike Nelson (Unlicensed)
Last updated: Dec 28, 2022 by Paul Hitchcock
2 min read

Problem

Bad statistics can cause poor query performance and should be updated periodically.

Some examples of symptoms:

  • When the Timeclock form is opened it lags and Crows Nest stops responding and the current employees records never load

  • The MR Queue on the Purchasing form times out and doesn’t load

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’.