Usually there is a warning strip that tells you why there are no results from the SQL Server trace. However, there are a few basic conditions that need to be met before you get SQL trace information:
- Your are profiling on Windows Vista, 7, or 2008
- The SQL Server is on the local computer
- The SQL Server is not the Express Edition
- The SQL Server MOF is present and compiled
Hope this helps.