The system may include a troubleshooting activity recorder configured to record troubleshooting sessions. Each troubleshooting session may include a sequence of queries and query results. The troubleshooting activity recorder may include a query transformer configured to transform the queries and the query results into transformed queries and transformed query results before recording the troubleshooting sessions. The troubleshooting activity recorder may be configured to record the transformed queries and the transformed query results as troubleshooting session information in a troubleshooting activity database. The system may include a troubleshooting pattern learning unit including a graph builder configured to generate a troubleshooting pattern graph having query nodes and links between the query nodes based on the troubleshooting session information.