Issue
A SQL query is needed to determine the number of waveforms generated by each device in a PME system.
Product Line
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.0
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Environment
SQL Server Management Studio (SSMS)
Cause
When a database becomes too large this can lead to performance issues with the system. Waveforms take up a considerable amount of space. In order to begin troubleshooting the database performance problem it is helpful to see the number of waveforms recorded by individual devices in the system.
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.*
Run the following script in SSMS:
NOTE: Either copy the above script or download and run the attachment in SSMS
Below is an example:
A SQL query is needed to determine the number of waveforms generated by each device in a PME system.
Product Line
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.0
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Environment
SQL Server Management Studio (SSMS)
Cause
When a database becomes too large this can lead to performance issues with the system. Waveforms take up a considerable amount of space. In order to begin troubleshooting the database performance problem it is helpful to see the number of waveforms recorded by individual devices in the system.
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.*
Run the following script in SSMS:
use ION_Data
SELECT wl2.SourceID, s.Name as 'Source Name', COUNT(*) AS 'Number of Waveforms'
FROM WaveformLog2 wl2
inner join Source s on wl2.SourceID = s.ID
group by wl2.SourceID, s.name
order by 'number of waveforms' desc
SELECT wl2.SourceID, s.Name as 'Source Name', COUNT(*) AS 'Number of Waveforms'
FROM WaveformLog2 wl2
inner join Source s on wl2.SourceID = s.ID
group by wl2.SourceID, s.name
order by 'number of waveforms' desc
NOTE: Either copy the above script or download and run the attachment in SSMS
Below is an example:
Released for: Schneider Electric Singapore
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales enquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Centre
Find support resources for all your needs, in one place.
