PME 8.X, 9.0 - "ION_Data database almost full" misleading warning using SQL Express
Product Line
Power Monitoring Expert 8.x, 9.0 using SQL Express version
Envorinment
System Event Log - SQL warnings
Issue
Even though the .mdf file is considerably less than the 10 GB limit PME will still generate the warning messages if the total for the .mdf and .ldf files is over 10 GB.
Cause
The root cause is that PME is doing a simple query of the database that only returns the total combined size. This is useful for some purposes but it can be wildly inaccurate when determining if the database is about to be filled to the extent that further device log downloads will be suspended.
Resolution
Doing "EXECsp_helpdbN'ION_Data'" will give the totals for each log file and thus make the warning accurate.
Alternatively the sproc below may give the space used and unallocated (ie. free) by the data section in the .mdf.
USE ION_Data
EXEC sp_spaceused
Power Monitoring Expert 8.x, 9.0 using SQL Express version
Envorinment
System Event Log - SQL warnings
Issue
Even though the .mdf file is considerably less than the 10 GB limit PME will still generate the warning messages if the total for the .mdf and .ldf files is over 10 GB.
Cause
The root cause is that PME is doing a simple query of the database that only returns the total combined size. This is useful for some purposes but it can be wildly inaccurate when determining if the database is about to be filled to the extent that further device log downloads will be suspended.
Resolution
Doing "EXECsp_helpdbN'ION_Data'" will give the totals for each log file and thus make the warning accurate.
Alternatively the sproc below may give the space used and unallocated (ie. free) by the data section in the .mdf.
USE ION_Data
EXEC sp_spaceused
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.