Release 18th July 2021 - Maintenance Tasks

Module:
Agile Elite

Summary:
Remove Agile Elite Integration

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3243

Detail:
Remove references to our integration with Agile Elite for Carrier Labels and End of Day modules.

This was originally implemented for our warehouses in the US but they are now using our direct integration with FedEx and our integration with UPS using Ship Engine.

This will improve the longevity of the application by increasing the maintainability of the software and make it easier for developers to add features.

It will also make it clearer for users when using the application as legacy features will no longer be visible.

Module:
Database

Summary:
Reorganize SQL Server indexes to improve query performance and reduce resource consumption

Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3559

Detail:

Over time, indexes have pages where logical ordering (based on the key-value) differs from the physical ordering inside the data file. This means that there is a high percentage of free space on the index pages and that SQL Server has to read a higher number of pages when scanning each index. 

Index fragmentation can result in decreased efficiency of queries and impact SQL Server performance.

The solution to fragmented indexes is to reorganize indexes. Index reorganization is a process where SQL Server goes through the existing index and cleans it up. 

We have identified tables with high fragmentation and will perform index reorganization on these.