How to check current size of the SQL Database PME

Issue
ION_Data database size needed for quoting PME upgrade, eService, Migration, or DB Maintenance.

Product Line
Power Monitoring Expert 7.2.2
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024

Cause 1

The current, database size is required and the quickest way to obtain that knowledge is desired

Cause 2

User does not have public access to SSMS

Cause 3

A diagnostic file is not available for SQL DB analysis

Cause 4

User does not have access to Database Manager.exe found in ".../Power Monitoring Expert/system/bin"

Resolution 1

1. Open SSMS (you may use this application from the application server or from the DB server in cases where the PME application has been installed using the distributed architecture) and log in to the SQL Instance that PME is connected to
2. Expand the "Databases" folder
3. Right-Click on the ION_Data database
4. Hover the mouse over Reports
5. Hover the mouse over "Standard Reports"
6. Select the "Disk Usage" report

example:

Resolution 2

1. Open a file explorer from the PME Application server (the computer where the PME software has been installed locally)
2. Navigate to the file path where the PME application has been installed (by default, PME will install to the C drive under the following file path: "C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert...")
3. Continue to navigate to the "Diagnostic Tools" folder
4. Right-click the "Diagnostics Tool.exe" and select "Run as administrator"
5. Verify the file path for the diagnostics tool's output
6. Ensure that the "SQL Server Information" command has been selected within the list of commands on the right-hand side of the Diagnostics Tool
7. Select "Start Analysis" within the Diagnostics Tool's UI
8. Once complete, select the diagnostic that was created:
9. Once the folder that contains the recently created diagnostic opens, select the "Ouputs" folder
10. Select the "SQL Server Information.html"

example:

Resolution 3

1. Open a file explorer from the PME Application server (the computer where the PME software has been installed locally)
2. Navigate to the file path where the PME application has been installed (by default, PME will install to the C drive under the following file path: "C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert...")
3. Continue through the system folder, onto the bin folder
4. Once in the bin folder, right-click the DatabaseManager.exe and select "Run as administrator"
5. Once the program opens, right-click the ION_Data database and select the properties

Resolution 4

1. Open a file explorer from the PME Application server (the computer where the PME software has been installed locally)
2. Navigate to the file path where the PME application has been installed (by default, PME will install to the C drive under the following file path: "C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert...")
3. Continue through the system folder, onto the bin folder
4. Once in the bin folder, select the "Vista.exe" application
5. Use the PME credentials to log in to the Vista application
6. In the top left hand side of the vista window select "File" then select "New"
7. Use the "Diagram Objects" toolbox, usually located in the bottom right hand side of the screen to click and drag a "Data Log Viewer" onto the new vista page
8. Right-click the data log viewer
9. Select the tab from the configuration ui named "Query Server"
10. Select "Customer Query Server", then select the "Edit Link..." button
11. Double-click your query node, then double click the "Query Modules", the "Query 1" and then the "QM1 Query Register" in that order. Once that is complete, select "OK"
12. Select the "Query" tab and select "Edit SQL"
13. Type the following script into the notepad that appears on-screen:

    EXEC sys.sp_spaceused

14. Close out of the notepad, and select "Save" when the popup windows appears to ask you if you'd like to save your changes to the notepad
15. Select "OK" within your "Data Log Viewer Configuration" popup window
16. Double-slick your Data Log Viewer

example of the results:

發佈於: 施耐德電機Taiwan