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.
Solved! Go to Solution.
Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.
Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.Join webinar