Search SSWUG.ORG:

DATABASES

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