Contents
Where are extended event files stored?
log folder
System_health extended event files are stored in the log folder of the instance.
How do you create deadlock extended events?
First open SQL Server Management Studio (SSMS) and navigate to Management > Extended Events > Sessions.
- Right click on Sessions and select New Session.
- In the new window, enter a name for your event, we will use Deadlock_Capture for this example.
How do you view extended events?
This can be found by expanding the “Management” node with Object Explorer. You then expand “Extended Events” followed by “Sessions” which will give you a list of your sessions. After right-clicking on the session you want to view you can then select “Watch Live Data” as shown below.
Is the system _ health extended events session documented?
The system_health Extended Events session is very well documented by Microsoft here. I’ve talked about it before, in relation to Azure SQL Database, and, on the same topic we’re going over today, long running queries and waits (cause if you have a long running query, you have waits).
How many rollover files does system _ health session retain?
An elaborate way would be to archive the .xel files themselves (or periodically take snapshots into your own storage), but I have two simpler solutions that might work for you. By default, the system_health session retains 4 rollover files of a maximum of 5 MB each, allowing you to retain 20 MB of data.
How big is the system _ health session file?
First and foremost, similar to the error log, this session consists of four files, each 5mb in size, rolling over as they get filled. For systems with a very high degree of activity, that means the information here may only be hours old.
What to do with system _ health xevent session?
The system_health XEvent session can contain some very useful troubleshooting information, but that data can easily get pushed out by short retention settings or too much noise. You can make some minor changes to this session to make the data you keep more useful and last longer. See these related tips and other resources: