Using WMI alerts to import SQL Server Default Trace events This is an off-site link.  Please review our Terms of Service for additional information.

(Svetlana Golovko) SQL Server has a Default Trace that runs automatically to collect various metrics that are used to help you monitor SQL Server. By default SQL Server only keeps the last 5 trace files that are created and deletes older files. Every time a trace file reaches 20MB or when the SQL Server instance is restarted, the oldest trace file is deleted.

Read this article...

comments powered by Disqus