Spotlight Session

SQL Server Archaeology: Dig into the Past with system_health [DBA-322-S]

Speaker(s)Jonathan Kehayias

Duration: 90 minutes

Track: Enterprise Database Administration & Deployment

Archaeologists dig to find meaning and historical facts about events that occurred in the past, and as DBAs, we are often challenged with situations where a problem is reported after it no longer exists on the server. The system_health session in SQL Server 2012 is a game-changer for post-mortem diagnostics of problems, and this session will show you how to dig into the information that is available to see the history of your SQL Server instances. We’ll look at what’s being collected and how to leverage it for real-world problem identification.

Evaluate Session