Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    How much memory does a single data log value consume within PME?

    Issue
    How much memory does a single data log value consume within PME?

    Product Line
    Power Monitoring Expert (PME)
    StruxureWare Power Monitoring (SPM)
    ION Enterprise (ION-E)

    Environment
    SQL server databases

    Resolution
    This value can vary based on the installed version of PME for the system, but this can be checked through SQL Management Studio.

    ** Warning:  Only those familiar with SQL server and PME should be working with SQL Management Studio.  Making direct modifications to the PME databases can leave a system inoperable and require restoration from back ups. **

    1)  Log in to SQL Management Studio
    2)  Expand the databases folder, right click ION_Data, select Reports < Standard Reports <  'Disc Usage by Top Tables'



    3) This will produce a report that shows the memory usage per table within the database as shown below.



    4) Divide the number of records by the Data (KB) column for the DataLog2 table.  This will give an approximate value of the memory usage for a single row entry.
    2,265,592 / 95,808 = 23.6472110888, so each row entry within the DataLog2 table consumes approximately 23.67 kilobytes of hard drive space.
    This example was taken from a PME 8.1 test system.

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance