Not alone with SQL Server you would be able to identify the root cause of a performance issue or to monitor any kind of activity. As you may be aware SYSMON (PERFMON) and PROFILER will help to some extent of finding offending processes on the SQL Server for further fine tuning for queries or tasks. Still there is a need to dig deeper on the troubleshooting tools that are required within your SQL platform irrespective of versions such as SQL Server 2000, 2005 and 2008 (upcoming). Until the age of...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2008/06/05/sql-server-troubleshooting-tools-pssdiag-sqldiag-sqlnexus-rml-utilities-and-readtrace-which-one-to-choose.aspx