Have looked through msdn but cant find answers to these:
Any help much appreciated:
In simple recovery mode:
Is there any TSQL or alternative functionality that will provide a notification either written to the event logs or a message or an alert , stating that the Microsoft automatic transaction log truncation is happening i.e when a checkpoint is reached sql server truncates. (According to this: http://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx)
Is there anyway to find out how long it takes for automatic truncation to happen /how long it takes for the transaction log to be truncated?
Does the SQL Server condition performance alerts happen in real time or in intervals or say 5 mins?