See two ways you can make the relevant data in the system_health session last longer and not get drowned out by noise.
Category: Extended Events
Access the system_health file target without tedious string parsing gymnastics.
I finish up my series on replacing the default trace with views to simplify consumption and a caveat about reports in SSMS.
I continue my series on replacing the default trace with a more efficient and more complete Extended Events session.
I start a series explaining how I evaluated the default trace and decided to replace it with a slimmer Extended Events session across all of production.
See how you can use Extended Events to find your worst performing checkpoints.
A quick post to show how to pull autogrow events from the default trace.