Optimizing SQL for performance with AyaNova

Wanted to post here a few SQL settings that can improve your SQL performance even more:

  • In your SQL Management Studio right-click on your AYANOVA database, select Properties, under Options, set AUTO CLOSE = FALSE

  • Right-click on your server name via SQL Management Studio, select Properties, under Memory make sure not using AWE for allocation

  • still under your server’s Properties, under Connections make sure that maximum number of connections is 0 (unlimited)

  • still under your server’s Properties, under Connections, make sure the Remote query timeout is 600

  • Do not forget to restart the server after making any changes.

  • Joyce