Technical FAQs

Ask a Question

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. 
 
Was this helpful?
What can we do to improve the information ?