Storage Size Management in eCatalog


eCatalog includes a comprehensive utility designed to monitor and report on hard disk and database usage effectively. This utility provides a detailed breakdown of storage consumption, helping administrators manage system resources efficiently.


Key Features of the Storage Size Utility:


Temporary Blob Storage Analysis:


  • Records and Size
    The utility will report on the number of records for temporary blobs (attachments), detailing both the actual size and the compressed size of these files, which assists in understanding their impact on storage.
  • Temporary Physical Files Monitoring:
    • Disk Usage: It provides measurements in megabytes of the space used by temporary physical files on the server, offering insights into the amount of temporary data stored.
  • Database Table Size Reporting:
    • Large Tables: 
      The utility lists all database tables that exceed 5MB in size, ordering them from the most to least used in terms of disk space. This feature is particularly useful for identifying data-intensive tables that may need optimization or cleanup.


Benefits of Using the Storage Size Utility:


  • Optimized Resource Management
    By providing clear metrics on data storage and usage, eCatalog helps administrators make informed decisions about data management, potential system optimizations, and capacity planning.
  • Proactive Maintenance
    Regular monitoring of storage usage can help in proactive system maintenance, preventing potential performance bottlenecks caused by unchecked data growth.
  • Enhanced System Performance
    Understanding storage dynamics enables administrators to implement strategies that maintain or enhance system performance, such as adjusting storage allocation, cleaning up old data, or compressing files to reduce space consumption.