Trend Analysis of SQL Error Logs: Seeing Beyond the Error

A session at Boise Code Camp 2016

Saturday 19th March, 2016

4:30pm to 5:45pm (MST)

Session Level: 200

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.

About the speaker

This person is speaking at this event.
Paul Ou Yang

Senior DBA at Micron Technology bio from LinkedIn

Paul is a Senior Database Administrator at Micron Technology Inc. where he started working with databases since 2000.

He is a Microsoft Certified Master in SQL Server 2008 and specializes in performance troubleshooting, automating DBA tasks, and managing large data centers.

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 4:30pm5:45pm MST

Date Sat 19th March 2016

Short URL


View the schedule


See something wrong?

Report an issue with this session