Manually update database statistics
Database statistics are used to ensure that your database is providing data to Accounting CS as efficiently as possible. Typically these statistics are automatically updated as needed. Manually updating the statistics can be useful if response times are slower than usual or if a significant number of changes have been made to the data at once.
- SelectHelp, thenUpdate Statistics.noteThis command is not available if you are working in the Virtual Office CS (VO) or Software as a Service (SaaS) environments where the database is maintained by the administrators at Thomson Reuters.
- If the process fails, contact your database administrator to verify the following configurations:
- TheServer authentication modeis set toSQL Server and Windows Authentication modefor your SQL Server instance.
- The database owner loginCreativeSolutionsPracticeCsDatabaseOwnerexists.
- The database owner loginCreativeSolutionsPracticeCsDatabaseOwnerhas the proper permissions.noteGrantpermission is needed forConnect SQLandView server state. If one or both aren't granted, run the following script.USE MASTER; GRANT CONNECT SQL, VIEW SERVER STATE TO CreativeSolutionsPracticeCsDatabaseOwner;
- There is sufficient RAM available on both the workstation and the server.
- After verifying these items, selectHelp, thenUpdate Statisticsto manually update the statistics in the database.
