Learn how to deep dive into your logs using SQL
Logging is a critical part of the software development lifecycle - enabling developers to debug their apps, DevOps/SRE teams to troubleshoot performance issues, and security admins to analyze access patterns.
In this session, Google Cloud Product Manager, Afrina M, and Senior Staff Software Engineer, Summit Tuladhar, will demonstrate how to efficiently deep dive into your logs, including:
Walk through the essential tools you need to perform network and security analytics, and application troubleshooting using log data
Show you how to perform log analysis using SQL
Demonstrate how to use tools such as Logs Explorer, Log Analytics, and alerting
02:45 Google Cloud Operations overview
05:31 Structured vs unstructured logs
09:26 Collecting logs to use SQL (managed and do-it-yourself)
13:39 Log Analytics in Google Cloud Logging
14:45 Why SQL?
15:55 Powerful search function
16:50 Logging use cases
17:05 Troubleshooting use case (developers and DevOps)
18:21 High volume network analysis use case (IT)
19:26 Investigating audit logs use case (security)
20:25 Live demo
32:20 Security insights using SQL
39:40 Resources and next steps
41:10 Q&A
Resources
Query and view logs: https://cloud.google.com/logging/docs...
Top 10 reasons to get started with Log Analytics: https://cloud.google.com/blog/product...
Cloud Logging pricing for Cloud Admins: https://cloud.google.com/blog/topics/...
Google Cloud Security Analytics: https://github.com/GoogleCloudPlatfor...
Join, learn, and engage with the Google Cloud Community: https://goo.gle/cloud_community
