In this version optimization functions are included:
•Optimize writing in DB using GlobalLock
•Optimize methods with caching
•Exclude SignalR for translations
•Optimize writing information in log files if method is recognized
Database optimizing procedure:
•Optimize SQL queries in DB and added new indexes
•Store procedure added for fragmentation indexes and statistic SQL
SQL procedure that has to be executed manually:
exec AzureSQLMaintenance 'all', @LogToTable=1
select * from AzureSQLMaintenanceLog
Note: The optimization can be run frequently, but the execution itself will have effect on database performance. Therefore try to run the optimization outside business hours or other time when system activity is low.