From all the comments we have received so far it appears that we have hit the mark with the “agent-less” feature of xSQL Profiler. Unlike many of the database monitoring / diagnosing tools that require the installation of service agents on the target servers and consequently require days to deploy, xSQL Profiler does not need any agents. The xSQL Profiler application and service are installed in minutes on a single machine from where you can define and schedule traces to run simultaneously on as many target servers as you need. The trace data from all servers are pulled automatically on predefined time intervals into the central repository. It can’t be simpler than that. And did we mention that it is completely free for up to two SQL Server instances? Go ahead, download your copy today and let your colleagues know.
PS not only can you trace SQL Server 2000, SQL Server 2005 and SQL Server 2008 but you can also trace SQL Server Express and MSDE instances.