Trade Simple November 2011 Product Update - Part 3
Infrastructure Activities Database housekeeping/management: For many months, the infrastructure team has been dealing with serious issues around the lack of space available for the trade simple databases on both the Hospitality and eparts platforms (see also Document Repository management below). The following steps were taken to address these issues: All non-critical data was identified and purged from the system. This was done out of hours to minimise possible performance issues. Ongoing housekeeping procedures ensure that this a continuous process This freed-up hundreds of Gigabytes within the database. For comparison, approximately 1GB (10 9 bytes) is required to store about 1,000 average-length novels in English or 7 minutes of HDTV! Unfortunately,however, SQL Server did not make this free space available on the disks for other databases to use — so the problems continued After much research and testing the Infrastructure Team now understand f...