troubleshootingsql.com
Default Trace–Performance Issues
There are multiple events that a default trace in SQL Server 2005 and above tracks which can be significantly useful for finding out areas of improvement. The events that I will be concentrating on…