Does anyone have a good reference for setting up extended events and how to do it to get the info you want? We are using 2008 R2 and are looking to get information about when tempdb grows and what caused it to grow. I believe this will get the growth, but I would like to drill down more and find out why it grew.
CREATE EVENT SESSION tempDBGrowth
ADD EVENT sqlserver.databases_data_file_size_changed
WHERE database_id = 2)
ADD TARGET package0.asynchronous_file_target
(SET filename = 'c:\xelog.xel', metadatafile = 'c:\xelog.xem')
ALTER EVENT SESSION tempDBGrowth ON SERVER STATE = START
Also, it seems that BOL does not have a great explanation of each action, or I just can't find a detailed explanation for each one. So, really I am just asking for a good reference for Extended Events and any "hints" as to how I can get more detail on the growth here and what query(s) caused it to grow.
PFE - MicrosoftSQL Know-It-AllHow to post data/code on a forum to get the best help - Jeff Moden