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