SQL Maintenance?

I have been running Ayanova for 6 years now and my database is sitting at 500Mb +. Is there any maintenance withing Ayanova or SQL Express to compact the database as it is starting to get very slow and takes several seconds for work orders etc to save, print etc.

AyaNova 6 marks the first release where we’ve been able to make performance changes specific to Firebird and Microsoft SQL independently to take advantage of techniques specific to each platform. As per the What’s New in AyaNova 6 in the Help documentation, we were able to do far more with Microsoft SQL server in terms of performance as it supports more features for high end performance (such as index clustering) however both platforms have benefited, most noticeably in cases where the database is very large.

If you are experiencing a slow down in performance compared to previously, you will want to make sure you are doing your regular SQL maintenance. See topic Recommendation-when-using-SQL-(Express-or-licensed-Server) to get you started and than refer to your SQL documentation.

Also check too your LDF file as per topic Large-LDF-log-file-for-SQL-Server-can-cause-problems. Again, do check SQL documentation for details.

After have confirmed the above, you will also want to check the load on your SQL server itself - make sure it isn’t running out of memory or going to 100% CPU utilization.

  • Joyce