Trend Analysis of SQL Error Logs: Seeing Beyond the Error

Speaker(s)Paul Ou Yang 

Duration: 60 minutes

Track: Enterprise Database Administration & Deployment

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.


View Recording

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

Sign In


Not a PASS member? Click here to register.