If the system is getting continually slower over a period of time it may be caused by the SQL Server struggling for resources in some way. It could be caused by a variety of issues and there are a number of things that can be checked, including looking for warnings in the SQL application event logs.


Your IT Support or Database Administrator can look at the following issues:

  • Have any new applications been added to the server recently that might be taking some of the system resources? Checks on the processing speeds in task manager may help.
  • Some new virus checkers and definition updates have been known to cause speed issues. Review any file exclusion lists in your antivirus (AV) software. Excluding the following file types in virus scanning may help:
    • .mdb
    • .ldb
    • .mdf
    • .ldf
  • Is there enough available space on the server where SQL maintains the data files (.mdf/.ldf files)? A high % of available space is needed continually to enable transactions to be written to the database.
  • Is there enough memory on the SQL Server for the number of active Troika users? Please follow our recommendations in the following article.
  • Has there been any recent changes to the operating model? Check here to ensure it remains a supported operating model, Operating Models for Troika and WealthWorks+.
  • Running a maintenance plan to re-index the SQL database, and truncate the transaction log can also free up space and shrink the database. A suitable re-index script is available here.
  • Are there any long running queries or rogue processes running in SQL? Stopping and starting the SQL Server Services will kill any processes which aren’t required.
  • Check the 'Recovery Model' of the SQL database by checking the database properties in SQL Management Studio (SSMS). Let us know if the model is set to FULL as there are database size and resource implications using this recovery model.
  • Check the 'Auto Close' property of the SQL database by checking the database properties in SQL Management Studio (SSMS). It should be set to 'False', as per our System Requirements.
  • Check the SQL Server Configuration Manager and ensure the Shared Memory, Named Pipes and TCP/IP protocols are enabled:

  • Check the correct SQL services are running (SQL Configuration Manager) and stop unnecessary SQL Server Services which are not being used. Troika only requires the MSSQL Service and SQLAgent Service to be running. Consider stopping and setting other SQL Services such as SQL Reporting Services to 'manual', if they are not required.


In the event problems persist after reviewing the above, please contact support for further assistance.


These notes were last reviewed 03/2024.