Trend Analysis of SQL Error Logs: Seeing Beyond the Error

Paul Ou Yang
60 minutes
Enterprise Database Administration & Deployment
DBA, Architect
You carefully search for errors in the logs daily and fix them as they come. Recently, you noticed some errors are reoccurring and wonder when they started and what you could do differently. However the logs have already recycled and the information is gone, so you are left with the inquiry and go on with the next task. In this session, you will learn how to automatically parse the errors from multiple SQL error logs using PowerShell, store the data in a central database, and create reports to visualize the information using SQL Server Reporting Services. Analyzing error trends will allow you to see solutions that will lead to greater process efficiency.
Basic Knowledge of PowerShell, T-SQL, and SSRS

View Recording

To access the session recording, please login or register first:

Sign In

Not a PASS member? Click here to register.