{}

Nhãn hiệu của chúng tôi

Impact-Company-Logo-English Black-01-177x54

Chào mừng bạn đến với Trang web của Schneider Electric

Chào mừng đến với trang web của chúng tôi.
Tìm các câu hỏi thường gặp
A script to determine the number of waveforms for each device in the PME system
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:
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

NOTE: Either copy the above script or download and run the attachment in SSMS

Below is an example:

Example

Schneider Electric Việt Nam

Phần đính kèm
WaveformCount.SQL.sql [229 Bytes]
Tìm hiểu thêm
Phạm vi:
Bài viết có thể hữu ích
Tìm hiểu thêm
Phạm vi: