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 to determine how many Waveform Captures a meter has in the database?

    Issue:
    Waveform captures can create a heavy burden on database size due to the amount of data they contain. Devices that are not properly configured for Power Quality, can generate large amounts of unnecessary waveforms that result in rapid growth of the ION_Data database. If waveform captures are causing excessive database growth, it is necessary to identify which device(s) are generating the most waveforms so they can be configured accordingly. 

    Product Line:
    SturxureWare Power Monitoring 7.0.x
    Power Monitoring Expert 7.2.x, 8.x

    Environment: 
    SQL Server Management Studio

    Resolution:
    *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*


    The attached SQL query will return a listing of all devices in the system that have waveform captures, as well as the amount of waveform captures for that device. Devices that have the largest number of waveform captures should be investigated to determine if they are generating an excessive amount. 
     

    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