NSP code optimizations

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 optimizations

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