# System Load Analysis Demo

> Explore how PuppyGraph analyzes system load with powerful graph queries. Learn how to identify performance issues and optimize system operations in real time.

- Canonical URL: https://www.puppygraph.com/demo-videos/system-load-analysis-demo
- Video: https://www.youtube.com/watch?v=Pv3KwJzGkxM
- Category: Use case

This demo showcases how to analyze and visualize high CPU utilization across components within a large call graph, using PuppyGraph's powerful query capabilities. By querying historical records related to components with a CPU load ratio above 0.9, users can swiftly identify patterns of heavy usage and the associated component and invocation information. Additionally, the application of the PageRank algorithm ranks the importance of each component, providing insights into which components are critical within the network and might need optimization or monitoring to prevent system overloads. This practical approach helps in proactive system maintenance and optimization in complex environments.

## Tech stack

-   PuppyGraph
-   Apache Iceberg
-   Docker

## Queries in natural language

-   Query historical records and related components with a CPU load ratio greater than 0.9
-   Query historical records of components with CPU usage exceeding 90%, as well as corresponding component and invocation info
-   Rank the importance of each component using the PageRank algorithm

[Visit the GitHub repository](https://github.com/puppygraph/puppygraph-getting-started/tree/main/use-case-demos/system-load-analysis-demo)