Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Extended Events file target Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 2:58 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 12:05 PM
Points: 627, Visits: 4,980
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.



Post #1496597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse