Extended Events file target

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  September 19, 2013 at 2:58 pm

  #298945

  Hi all,

  I've been reading BOL and searching online for answers, but wasn't able to find any.

  I'm putting together an event session that has a target of asynchronous_file_target. My questions are:

  If my max_rollover_files is set to 2, and the max_file_size is set to 2MB, and the first and then the second file are filled up, what does sql server do then? Does it stop the extended event? Does it start writing to file 1? Does it create a new file and delete file 1?

  Also, is the value for max_file_size in MB or GB or something else?

  Thanks in advance.