cancel
Showing results for 
Search instead for 
Did you mean: 

How to utilize Prognosis Trouble Shooting database to view the historical memory usage of a process?

Highlighted

How to utilize Prognosis Trouble Shooting database to view the historical memory usage of a process?

Prognosis has a standard database collection Trouble Shooting database for each platform (Windows, Unix & Nonstop), it is started by default during installation. The Trouble Shooting database collects a lot of operating system level and network level records as well as Prognosis specific records data and metrics for diagnostic purpose. Taking Windows for example, the database collects records such as NtProcess, NtMemory, NtCPU, NTDiskLogical, NtNetworkInterface, MpAvailability and PrognosisNode etc. 

Trouble Shooting database collection (and its summary database Capacity Planning) can be very useful at troubleshooting stage. For instance, if a process uses high CPU or memory, Trouble Shooting database can provide insight into what happened in the past and the pattern of the spikes by replaying and graphing the historical data.

For example, to review a process's memory utilization on a Windows server in line graph:

1. Replay the Trouble Shooting database;
2. Select the NTJOBS record view;
3. Right click on it and select Properties...
4. In the Data View Definitions, double click the View Name;
5. Select the ProcessName and PageFileMB fields;
6. In Where Clause window, set the where clause, eg, NAME CONTAINS "IRGUI", this is the interested process name;
7. In Presentation tab, select the Line Chart Type and set the Chart Intervals to a number that covers the time frame that the high memory occured, eg 500, or 1000;
8. In Custom Legend tab, customize the Label to include the requried items, eg, NAME and PID;
9. Click OK and then drag the slider bar to the begining or end of the collection, and then clcik on Fast Backward or Fast Forward button to replay;
10. Wait till all the chart intervals are shown. 

An example is as below.
MEM PNG (1).png

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to utilize Prognosis Trouble Shooting database to view the historical memory usage of a proc

Here is a short video to demo how to replay the data in line graph. 
The same approach can be used in any database collection/summary replay and analysis.

View solution in original post

Tags (1)
1 REPLY 1
Highlighted

Re: How to utilize Prognosis Trouble Shooting database to view the historical memory usage of a proc

Here is a short video to demo how to replay the data in line graph. 
The same approach can be used in any database collection/summary replay and analysis.

View solution in original post

Tags (1)
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar