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
發佈於: 施耐德電機Taiwan
需要協助？
產品選型工具
快速輕鬆地為您的應用找到合適的產品和附件。
取得報價
立即線上提交您的銷售需求，專業團隊將主動聯繫您。
購買地點
輕鬆在您所在地區找到最近的施耐德電機經銷商。
支援中心
在同一位置找到滿足您所有需求的支援資源。